Using the UsedRange method helped remove the blank rows when printing,
but they still exist on the sheet and continue growing. Instead of
having 200 rows of data, the sheet thinks it's got 1600 rows of data. It
makes using the scroll bar near impossible.
I tried simply deleting the blank rows manually and via code, but
neither had an impact. Any way to reset the rows so the scroll bar on
the right-hand side doesn't think there is data in the blank rows?
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!