Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

DialChart.zip