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?