VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

When you are trying to understand an unfamiliar workbook or Excel model, it can immensely help knowing which tabs are feeding into the one you are currently viewing. This little macro will give you a message box indicating any outside worksheet references found in the cell formulas of the ActiveSheet. 

Read More

VBA Code To Change All Shape & Chart Placement Properties

VBA Code To Change All Shape & Chart Placement Properties

I deal with shapes and charts on a daily basis and one of my (many) pet peeves is needing to resize column widths and screwing up the size of my shapes and charts. I'm going to share with you a few VBA macros that will allow you to change the Placement property of all the shapes and charts on your ActiveSheet with the click of the button. The last VBA snippet is the one I use personally almost daily. Enjoy!

Read More

VBA To Quickly Save As PDF Document From Selected Excel Worksheets

VBA To Quickly Save As PDF Document From Selected Excel Worksheets

Below is a simple VBA macro that will allow you to quickly turn your selected worksheet(s) into a PDF file in a snap. The code is written to save your document in the same folder as the Excel file currently resides. If you need to make modifications, hopefully, you will be able to follow along with my code comments and customize the code to your specific needs.

Read More