Search results 113

  2. Search results
  3. rows
Sorted from new to old.
Card image
WorkbookOpenAsk_ANmar

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

2018Jul17
Card image
SplitTo2DArray

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

2018Jul9
Card image
[TAB] inside textarea

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

2018Jul6
Card image
SortArea3

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

2018Jul4
Card image
Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

2018Jul4
Card image
FormulasFlatten

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

2018Jun30
Card image
CellRead (SimpleLookup)

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

2018Jun25
Card image
LogSheet_Add + LogSheet_Clear

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

2018Jun24
Card image
RowsCount

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

2018Jun22
Card image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16
Card image
BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16
Card image
BrowseFolder

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

2018Jun14
Card image
GoToInternet

Opens webpage from within Excel, using default browser

2018May22
Card image
SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

2018Apr27
Card image
DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

2018Apr23
Card image
No Cache

No cache on client browser

2018Apr23
12...78