Set Print Area, Ignore Formulas

[gerlingc]

I am looking for a VBA Macro that sets the print area on the active sheet from A1 to the last used cell (the number of columns and rows is not consistent) and ignores "" returned by formulas.

Thoughts?

Thanks!

[WasWodge]

Not sure exactly what end result you are expecting but try...

Please Login or Register  to view this content.

[gerlingc]

Thanks for your response.

This is great with the exception that it ignores any cell with a formula. Ideally, I would like it to include any cell with a formula that returns a value (including 0), but not a formula that returns a blank.

[WasWodge]

See if either of the codes below give you what you require

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[gerlingc]

Both do exactly what I wanted. For this application, PArea2 works better.

Thank you so much!

[gerlingc]

Both do exactly what I wanted. For this application, PArea2 works better.

Thank you so much!

[WasWodge]

Both do exactly what I wanted. For this application, PArea2 works better.

Thank you so much!

Happy it helped (PArea3() was me doing overkill just in case)