Hi.
I have a spreadsheet with about 15 tabs. Of these 15 only three will be visible to users & they will need the ability to print them as a packet (i.e. all three at one time). My plan has been to create a simple a "print packet" button & connect it to a macro/vba. But I'm running into print problems.

Two of the tabs (labeled "2 - Doc Prep Documents" & "3 - Closing & Funding Docs") contain formulas that either return data from other worksheets or return a blank (" ").

Example:
> In worksheet "2 - Doc Prep Documents", cell G23 the formula is: =IF('Data Validation Lists - DP'!D5="","",'Data Validation Lists - DP'!D5)
> In worksheet "2 - Doc Prep Documents", cell D23 the formula is: =IF(G23="","",CHAR(163))


Excel keeps wanting to print ALL the cells that contain formulas, even if there is no value in them. I've been trying to write something that will:
1) Filter out the blanks on the two aforementioned tabs
2) Print all three pages
3) Then turn off the auto-filter (so that all the rows are displayed).

I don't want to print the blank cells (even if there is a formula in them).

The columns I need to print are columns A:K and the rows, as I mentioned, will vary based on other user selections.

The three tab names are:
"1 - Request" -- nothing fancy here...this one is set to go.
"2 - Doc Prep Documents" - this is one that I'm stuck on
"3 - Closing & Funding Docs" - this is one that I'm stuck on

Can anyone help a brotha out?

Thanks,
David