Search results 59

Sorted from new to old.

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Sep23

StartApp-IfNotStarted

Checks if application is already running, returns 1 or 0 My first function

Aug3

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

Aug2

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

Jul31

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

May16

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Apr15

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Mar3

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Feb25

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

Jan28

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

1 2 3 4