Search results 60

Sorted from new to old.
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
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

Card image
HyperlinkFunction

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

Card image
Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Card image
Range2ANStr

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

Card image
ANmaSQL_UpdateDateStatement

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

Card image
ANmaSQL_InsertStatement

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

Card image
Export2CSV

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

Card image
ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

Card image
CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

Card image
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Card image
RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Card image
Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

Card image
Excel crashes when File > Print

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

Card image
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...