Search results 39

Sorted from new to old.

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

Tue 1PM

Pagebreak and Pagebreak preview

When setting the location of pagebreak, you need to have that sheet view set to ...

Nov11

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

FindLinks xla

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

2024Feb9

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

ANmaRemoveDuplicates

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

2022Sep25

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

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

CSVs2Sheets

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

2021Oct5

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Excel ribbon

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

2021Aug13

RandomUniqueID_Sheet

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

2021May29

Excel crashes when File > Print

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

2021Mar6

1 2 3