Hi All,
I am looking for a way to do the following
On my worksheet is 100 rows with columns A to G being used
Not all of the rows will have relevant information required all the time
I need to be able to hide the rows not required based on the contents of column F from row 6 to row 100
To further add to the mix I want the print area to change accordingly so if only 10 rows require printing the area adjusts automatically.
All I want to be able to do is press the button and the macro adjusts the print area to suit
Any thoughts?
Bookmarks