Search results 175

  2. Search results
  3. row
Sorted from new to old.
Card image
ANStr2Range

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

2022Nov11
Card image
AddDatabar_ConditionalFormatting

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

2022Aug22
Card image
LastRow_Remove

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

2022Aug16
Card image
Range2ANStr

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

2022Jul19
Card image
ASP Classic Page Cache

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

2022May20
Card image
Export2CSV

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

2022May16
Card image
GetHeaders

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

2022May5
Card image
BrowserSetting

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

2022Apr29
Card image
CreateUniqueList

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

2022Apr26
Card image
DynamicFill

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

2022Mar11
Card image
OpenAnyFile

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

2022Jan28
Card image
IsError_Range

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

2021Dec30
Card image
RowList_Matching

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

2021Dec27
Card image
Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26
Card image
Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2
Card image
ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3
12...6...1011