Search results 209

Sorted from new to old.
Card image
Autofit height iframe

iframe with animated gif to show while loading content, when iframe is fully ...

Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

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
ANmaVLookup

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

Card image
ANStr2Range

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

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
AddDatabar_ConditionalFormatting

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

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
Range2ANStr

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