Search results 124

Card image cap
AskForFolder

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

Card image cap
Convert_Dash_to_Zero

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

Card image cap
Range2Block

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

Card image cap
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

Card image cap
ANStr2Range

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

Card image cap
AddDatabar_ConditionalFormatting

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

Card image cap
LastRow_Remove

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

Card image cap
Range2ANStr

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

Card image cap
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

Card image cap
ASP Classic Page Cache

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

Card image cap
Export2CSV

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

Card image cap
GetHeaders

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