Search results 33

Sorted from new to old.

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

Files_FoundHours

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

2024Apr30

MatchIfUp or MatchIfRev

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

2024Apr8

ConcatenateStrings_AmongString

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

2024Jan17

SettingRead_Ajax + SettingRead_Ajax_IntoObject

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

2024Jan12

ANStrFind_AndOrAdd

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

2023Dec19

UserChanged_Log4

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

2023Nov28

Between_2Chars

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

2023Nov22

OpenAnyFile

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

2022Jan28

Subtotal_Indirects

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

2021Nov26

Add2Column

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

2020Jan3

GeneratePostID

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

2019Dec19

DialChart - Excel-VBA

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

2019Apr27

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9

1 2 3