AmIMobile

Check if browser is for a mobile or tablet, or not. This was before we have ...

Ask4Folder

Asks user for a folder, starting with certain folder

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

SplitTo2DArray

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

[TAB] inside textarea

Allow textarea's to accept TAB key (ASCII code 63) Could use some enhancements, ...

TabManager.zip

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

Sort1Col

Sorts a column in Excel, easily, with options

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

CellRead (SimpleLookup)

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

RowsCount

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

MatchIf_ThenDelete

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