Search results 253

Card image cap
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

Card image cap
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

Card image cap
BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

Card image cap
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

Card image cap
DeleteAllShapes

Delete all shapes in a sheet

Card image cap
FileDate_Formatted

Using FileDateTime to get file date

Card image cap
Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

Card image cap
FindName

Finds a name in a workbook, returns true or false

Card image cap
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

Card image cap
ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

Card image cap
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

Card image cap
CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...