Search results 18

Sorted from new to old.

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

Feb9

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

Protecting VBA code

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

2022Jul6

CSVs2Sheets

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

2021Oct5

Excel ribbon

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

2021Aug13

Excel crashes when File > Print

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

2021Mar6

Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

2020Dec20

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

2018Aug25

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

1 2