Search results 78

Sorted from new to old.

ANmaPairedStrings

Build pairs of lists of strings and returns both strings Takes the worksheet, ...

Mon 5AM

ANStrSearch2

Searches for an item in an ANStrList list by comparing the left part of items ...

Nov3

ANmaTable_FieldValue_Concat

Concatenates fields in certain row each with its header and returns the full ...

Jul26

DuplicatedList

Returns list of duplicated items in a range as ... ' ...

Jun21

ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

Variable_PerLocation_FromFullLine

Extract set from ANstring, like 2nd set of variable list using specific ...

2025Oct16

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

ANmaUploadFTP_ANstrFilesto1Folder

Upload all files found in ANStr list of files into 1 folder. Passing all ...

2025Aug7

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

2025May26

ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

2025May25

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

2025Mar24

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

2025Mar16

1 2 3 4 5