In my macro, I loop through my sheet at 35 row intervals looking for a non null if column A. If I find a null in column A, I back up a row until i find a non null in column A. Once found, I set a page break. I then increment another 35 rows and do the same test.
The logic seems to work well excpet that current print area is getting in the way and I can't seem to clear it. I do not know how to clear the print area in the macro (if someone knows how that would be great) however, I can't get the print area to clear even if I do a "Clear Print Area" under Page Layout of the Toolbar Ribbon (Excel 2007)
Can someone help?
Thanks...
The logic seems to work well excpet that current print area is getting in the way and I can't seem to clear it. I do not know how to clear the print area in the macro (if someone knows how that would be great) however, I can't get the print area to clear even if I do a "Clear Print Area" under Page Layout of the Toolbar Ribbon (Excel 2007)
Can someone help?
Thanks...