Search results 96

  2. Search results
  3. Workbook
Sorted from new to old.
Card image
RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29
Card image
ANmaRemoveDuplicates

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

2022Sep25
Card image
ANmAdvancedFilter

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

2022Sep15
Card image
HyperlinkFunction

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

2022Aug24
Card image
AddDatabar_ConditionalFormatting

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

2022Aug22
Card image
Range2ANStr

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

2022Jul19
Card image
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6
Card image
ANmaSQL_UpdateDateStatement

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

2022Jul4
Card image
Export2CSV

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

2022May16
Card image
AutoSaveOn

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

2022Feb23
Card image
RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27
Card image
Excel ribbon

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

2021Aug13
Card image
RandomUniqueID_Sheet

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

2021May29
Card image
Excel crashes when File > Print

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

2021Mar6
Card image
ToolPath

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

2021Jan12
Card image
Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22
123...56