Search results 202

Sorted from new to old.

ANStr2Range

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

2022Nov11

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

Range2ANStr

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

2022Jul19

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

CreateUniqueList

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

2022Apr26

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

1 2 ...6 ...12 13