Print Range Macro

[Armitage2k]

I am using this code to define the printing range of my Picture sheet. Depending on if a certain cell is empty or not, the page will be printed or not.

Please Login or Register  to view this content.

The problem is that all cells which I check contain formulas, which are considered as empty by excel, thus the page is not printed, despite it having content.

I already tried to replace the

Please Login or Register  to view this content.

but without success. Any ideas on how I can fix that nasty little problem?

Thanks,
A2k

[Armitage2k]

really no one has any clue...? Come excel-gods, dont let me loose faith in you!!

A2k

[Leith Ross]

Hello Armitage2K,

See if this version works. If not, post your workbook for review.

Please Login or Register  to view this content.

[Armitage2k]

Wonderful, progress has been made.

Well, now the printing range successfully changes. However, now instead of the entries which have a value, it decides to out all entries into my printing range, especially those which are supposed to be empty.

Enclosed my workbook.

A quick explanation of what I am doing. I am displaying data from another sheet on my Picture Sheet by using the formula

Please Login or Register  to view this content.

the problem is that I have pulled this formula down over 50 rows, but not all 50 rows on the other sheet have content. When I print the current sheet though, excel does not get that and still considers them with content because the formula is in these cells.

here my most updated code

Please Login or Register  to view this content.

thanks,
a2k

[Leith Ross]

Hello A2K,

You want to printout only the cells in each of the ranges that don't contain an empty string, yes? This can be done as long as the cells are contiguous (touching each other, unbroken).

For example, if "C47" is true then the full range is "A2:D50". If only cells "A2:D25" have data, no problem. However, if the cells were like "A2:D10, A15:D25", the five rows "A11:D14" would still be included in the printout.

Please Login or Register  to view this content.

[Armitage2k]

Hmmm.. this still does not work...

OK, I have pulled my formula down and have it in every row C1:C50.
Now, not every cell on the other sheet has data in it, thus is the cell is shown empty (If(VIP!C3=0,"",VIP!C3). Right now, only the cells from C3:C21 have content, but the printing range is still for the whole C3:C50.

Any ideas if that can be fixed?
Thanks for all your efforts Leith, and sorry for being a pest,
A2k

[shg]

Attaching a workbook and explaining in context would eliminate the flailing ...

[Leith Ross]

Hello A2K,

Based on the tests I have done, the code works correctly. We are spending a lot of time chasing ghosts. I agree with SHG. You should post your workbook for review.

[royUK]

Armitage why have you marked this thread tile s UNSOLVED? Read the Forum rules about thread titles 7 bumping your posts