Search results 181

Sorted from new to old.
Card image
Textbox focus issue fix

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

Card image
Ask4Folder

Asks user for a folder, starting with certain folder

Card image
Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

Card image
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

Card image
SplitTo2DArray

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

Card image
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

Card image
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

Card image
SortArea5

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

Card image
SortArea3

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

Card image
SortArea1

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

Card image
Sort1Col

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

Card image
FormulasFlatten

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

Card image
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

Card image
CellRead (SimpleLookup)

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

Card image
CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

Card image
LogSheet_Add + LogSheet_Clear

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