Search results 83

Sorted from new to old.
Card image
SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

Card image
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

Card image
CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

Card image
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

Card image
CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

Card image
RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

Card image
CellCommentRead + Save

Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...

Card image
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

Card image
Match3

Matching three values at the same time in three columns Just like Match the ...

Card image
Match2

Matching by two values at the same time in two columns Just like Match the ...

Card image
GetColumnName, ColumnName_XOffset

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

Card image
Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

Card image
Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

Card image
Filesin_Coll + Filesin_Cells

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