Search results 18

Sorted from new to old.

ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Sun 9AM

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

ANStrSort2

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

2025May25

Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used chart.js, this is ...

2024Sep30

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

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

2024Mar4

SwitchTextinCells

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

2024Feb23

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

2020Aug21

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

Counters

Finally, a neat simple js counter This one allows me to have negative counting, ...

2020Feb27

Animated form exit

Exit form with shrinking Shrinks the form, Pushes the form to the bottom of ...

2020Feb16

1 2