Search results 64

  2. Search results
  3. workbooks
Sorted from new to old.
Card image
Excel recovered files

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

2023Mar31
Card image
Convert_Dash_to_Zero

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

2023Mar14
Card image
ANmaRemoveDuplicates

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

2022Sep25
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
ANmaSQL_UpdateDateStatement

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

2022Jul4
Card image
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26
Card image
DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11
Card image
AutoSaveOn

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

2022Feb23
Card image
Excel ribbon

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

2021Aug13
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
ANmaCopy_Objects

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

2020Nov11
Card image
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11
Card image
CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31
Card image
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3
1234