I would like to select five (adjacent) cells in a column with my mouse and then run a macro which scans along every column in those five rows, hides (not filters) any column which has no data for any row in the selection (i.e. a blank column), filters out the rest of the entire spreadsheet so just those five rows remain in view, and then automatically resizes the cells' width and height to fill the size of the screen so that all the cells are visible.
How could I do this?
Thank you very much.
