Search results 44

Sorted from new to old.

Recalculate cells with UDF

Force Excel to calculate Cells with UDFs inside VBA code UDF = ...

Fri 7PM

Explorers

Open several windows of Windows file explorers (Explorer.exe) to certain ...

Aug2

ANmExcelTableAddress

Returns reference of a table in Excel workbook. This is because not all tables ...

Jul24

Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

2025Oct11

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

2025Mar20

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

2025Feb26

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

1 2 3