Search results 64

Sorted from new to old.
Card image
List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Card image
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

Card image
Range22DimArray

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

Card image
Excel recovered files

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

Card image
Convert_Dash_to_Zero

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

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Card image
AddDatabar_ConditionalFormatting

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

Card image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

Card image
Export2CSV

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

Card image
AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

Card image
Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

Card image
Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

Card image
Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

Card image
ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

Card image
ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...