Hiding Rows in excel.

Job ID: 34083455

Budget: $10 – $30 AUD

I have created a sheet that has a formula to automatically filter information from another sheet, which works perfectly, although when I save the filter information as a PDF it also saves 1000 empty rows (Which are set in the print area for progressive works).

If I was to create a normal filter (One not from a formula), the blank rows would automatically be removed and only the populated cells would save. I don't want to do this as I want to full lock the sheet and filtered columns don't lock.
Related categories: Visual Basic Data Processing Data Entry Excel