Search results 52

Card image cap
ANStrFind_AndOrAdd

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

Card image cap
MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

Card image cap
ReplaceStrings

Replace strings found in list of strings from inside a string, does taht make ...

Card image cap
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image cap
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image cap
ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Card image cap
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

Card image cap
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

Card image cap
ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...