Search results 108

Sorted from new to old.

Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

2023Mar29

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

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

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

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

RowList_Matching

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

2021Dec27

Subtotal_Indirects

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

2021Nov26

Highlight row of current month

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

2021Sep2

1 2 3 ...6 7