What are .NumberFormat Options In Excel VBA – Stack Overflow
Note this was done on Excel for Mac 2011 but should be same for Windows Macro: Sub numberformats() Dim rng As Range Set rng = Range(“A24:A35”) For Each c In rng Debug.Print c.NumberFormat Next c End Sub Result: General General Number 0 Currency $#,##0.00;[Red]$#,##0.00 Accounting _($* #,##0.00_);_($* (#,##0.00);_($* “-“??_);_(@_) Date m/d/yy Time [$-F400]h:mm:ss am/pm Percentage 0.00% Fraction # ?/? Scientific 0.00E+00 Text @ Special ;; Custom #,##0_);[Red](#,##0) (I just picked a random entry for custom)
jdawiseman.com: Computing the ISIN checksum in Excel
To facilitate settlement and hence trading of securities, each security has a unique identifying code. There are several types of identifying code, the one that is used internationally being the ISIN, or International Securities Identifying Number. Every security in almost every country has an ISIN (possibly excepting Colombia, whose government bonds-uniquely-appear to lack an ISIN). The structure of an ISIN is defined in ISO 6166, and the algorithm is described by Wikipedia. Defined below is an Excel VBA function LastDigitISIN(ElevenChars As String) As String that returns the last digit of an ISIN given the first eleven. UK securities also have a SEDOL number, also defined in Wikipedia. The function LastDigitSEDOL(SixChars As String) As String returns the last digit given the first ?6 characters. If the input is shorter than six characters it is left-padded with zeroes. ISINs of UK securities are typically made by prefixing the SEDOL with “GB00” (and perhaps with “IE00” for Irish se
xmodulo.com: How to make spreadsheets in a Linux terminal – Linux FAQ
a lot of the shortcuts for sc are inspired by those of vim (or I guess it’s bad news if you only know Emacs). So you can move around with the traditional hjkl keys: ‘h’ for left ‘j’ for down ‘k’ for up ‘l’ for left Or just use the arrow keys if you are not afraid of being burn for heresy. The second thing you might want to do in a spreadsheet is to enter some numerical value. I was a little thrown off at first because the insertion mode is a bit different here. To enter a numerical value in the selected cell press ‘=’, then your value. To enter some text instead, type ‘<', then your text. If you need to save your work at any time, use: P[name].sc to dump your work into a .sc file.
office.microsoft.com: Change or delete a defined name – Excel
Use defined names to make it easier to refer to a cell, range of cells, formula, or constant value. On the Insert menu, point to Name, and then click Define. In the Names in workbook list, click the name you want to change. Do one of the following: Change the name Type the new name for the reference, and then click Add. Click the original name, and then click Delete. Change the cell, formula, or constant represented by a name Change the name in the Refers to box. Delete the name Click Delete.
msdn.microsoft.com: The Integer, Long, and Byte Data Types
Three data types in Microsoft© Visual Basic© for Applications (VBA) can represent integers, or whole numbers: the Integer, Long, and Byte data types. Of these, the Integer and Long types are the ones you are most likely to use regularly. The Integer and Long data types can both hold positive or negative values. The difference between them is their size: Integer variables can hold values between -32,768 and 32,767, while Long variables can range from -2,147,483,648 to 2,147,483,647. Traditionally, VBA programmers have used integers to hold small numbers, because they required less memory. In recent versions, however, VBA converts all integer values to type Long, even if they are declared as type Integer. Therefore, there is no longer a performance advantage to using Integer variables; in fact, Long variables might be slightly faster because VBA does not have to convert them. The Byte data type can hold positive values from 0 to 255. A Byte variable requires only a single byte of memory,
Stack Overflow: How to check whether certain sheets exist or not in Excel-VBA?
On Error Resume Next Dim wSheet as Worksheet Set wSheet = Sheets(1) ‘ can also be a string, such as Sheets(“Sheet1”) If wSheet Is Nothing Then MsgBox “Worksheet not found!” Set wSheet = Nothing ‘ make the worksheet point to nothing. On Error GoTo 0 Else MsgBox “Worksheet found!” Set wSheet = Nothing ‘ set the found Worksheet object to nothing. You can use the found wSheet for your purposes, though. End If
MrExcel.com: VBA – How add worksheet with specified name?
This will insert a new worksheet after worksheet 1 and name it: Worksheets.Add(After:=Worksheets(1)).Name = “My New Worksheet”
Export or Save Excel Files with Pipe (or Other) Delimiters Instead of Commas – How-To Geek
Now here’s where the interesting part happens… Excel by default will use a comma as the delimiter, but if you open up Control Panel –> Region and Language, and then click the Additional settings button on the bottom…