Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...
2023Nov1
Detects how many dimensions an address has, This is what I call it dimensions ...
Nov8
Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...
Sep23
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
2018Aug9
Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...
2018Jun24
Reads < table .... < /table> found after index Have ability to opnly bring the ...
Sun 1PM
Checks (and/or removes) if an item was found in list of items and return 1 if ...
Sun 1PM
Checks if string has all words from ANStr inside Retuns 0 if not found or ...
Jan8
Replaces certain occurrence of a string with another inside a string. Like ...
Jul13
Reads bytes from file using FSO, Number of bytes can be decided as well as ...
2024Jan15
Encrypts (and decrypts) a string. To decrypt an encrypted string, use the ...
2018Jul25