Print area

[RJ1969]

Hello

I am trying to set a print area from A1:L5000. But everytime I do the “clear print area” it includes the column M, N, P and Q. I can’t figure it out just to set it from A1:L. I did reset the scaling to 82 but still does the same.

As you can you see on my sample that the A17:L thru A77:L are gray. If there is no entry then it should gray color.

Can you please add code in the VBA on the attachment I have attached.

Thank you.

[6StringJazzer]

I am having trouble understanding your problem statement.

• Why are you doing "clear print area" if you are trying to set print area?
• Scaling is unrelated to print area.
• Your print area is currently set to 'FEBRUARY 2021'!$A$1:$L$16.
• Your VBA does not do anything with the print area, not sure how your VBA relates to your question.
• I set your print area to A1:L5000 with no problem. See attached.

[RJ1969]

Hi,
That is not exactly what I wish to do.

I have been having an issue about setting a print area on some of my worksheets. Sometimes I was able to set it right but with this one I am having trouble with because I prints it includes where the P2/P3.
In the sample worksheet. As you can see A17-A77 were gray out that is should not be.
Let say I want to set the print area from A1:L5000. If I do an entry from A1:L77 then this only should be printed the rest will be gray out. If I add an entry to A77 then it should not be gray out and if I delete the entry in A77:L77 then is should be gray out. Although, I have an entry on P2 and P3.

I Just want to print where there only entry from A1:L5000 which does not include P2/P3.


Thanks.

[6StringJazzer]

It's still not clear what you want to do. Here is a slightly different version where I set the print area to A:L. It will only print the rows that are in use. I don't know what you mean by "gray out" because nothing in your file is grayed out. I don't see how P2 and P3 come into play because they are outside the print area.

[RJ1969]

ok.. thank you.

[RJ1969]

Hi,

Thanks.