Search results 118

Sorted from new to old.
Card image
ANmaFormatLastRow

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

Card image
ANStrVLookup

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

Card image
ANStrSort2

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

Card image
ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

Card image
HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

Card image
UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Card image
String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Card image
String_S

Generate repeated text, like String() the function but with ability to repeat ...

Card image
ANString_to_ListSelects

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

Card image
DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Card image
FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

Card image
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Card image
CountNumbers_inString

Returns how many numbers found inside a text

Card image
CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like