Hiding empty rows before printing..
Posted by newbie on August 03, 2001 11:36 AM
Hi again guys..
Need your help again..I got my data from A1:E100..
It is filled with colour , formula and border..
Let say..sometimes I just use only from A1:E50..
So..is there any macro which can detect the empty rows and hide it..so when I
print it..I dont want the border to appear..
the formula is ok..it show nothing..coz no data filled
ps: the empty rows still contain formula and border thats why i can't delete it..
Thanks in advance