I have a sheet of reference data (A1:I530), and I would like to create a macro that sets the print area for only rows that have a $ total in the H column, and a $ total in the I column. Stated another way, any row that is 0 in H or I columns wouldn't print. I only want this to apply to this individual sheet titled "Cost Codes".
I think this would be much more economical both for time and paper use than conditional formatting.
Does anyone have suggestions? Any help is greatly appreciated!
Thank you
Bookmarks