Search results 295

Sorted from new to old.

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Apr8

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Mar5

VBInstr_Numeric

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

Feb25

CutString11

Cuts long string from certain character to certain character with option to ...

Feb24

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Feb23

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Feb20

Int function in ASP Classic (cint vs fix)

If you are looking for a function ASP Classic (VBScript) to do what Int() does ...

Feb6

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Feb3

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

1 2 ...4 ...18 19