Search results 382

Sorted from new to old.

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

2024Aug21

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

StartApp-IfNotStarted

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

2024Aug3

FindZipFile_WShell

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

2024Aug2

FindImg_WShell

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

2024Jul31

ANmaSearch_OrFriends

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

2024Jul30

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

ANmaReplace_Occurrence

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

2024Jul13

JSON_To_Table

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

2024Jun6

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

ANmaHTMLTables_Combine2

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

2024May16

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

1 2 ...4 ...23 24