Prepare for the show: A framework for hiding rows and columns in your spreadsheet applications


Hiding a bunch of rows and columns in a sheet before showing it to your boss is inevitable.  I insert blank rows and columns around a table, so I can use the CurrentRegion property of the Range Object in my code. I add labels to all my named ranges in the sheet. I split outContinue reading “Prepare for the show: A framework for hiding rows and columns in your spreadsheet applications”