Search results 137

Sorted from new to old.
Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

Card image
Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

Card image
Zip_Folder

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

Card image
AskForFolder

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

Card image
Convert_Dash_to_Zero

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

Card image
Range2Block

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

Card image
Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

Card image
ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

Card image
DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

Card image
LastRow_Remove

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

Card image
ASP Classic Page Cache

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

Card image
Export2CSV

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

Card image
GetHeaders

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

Card image
BrowserSetting

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

Card image
BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

Card image
DynamicFill

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