Making print range dynamic in macro
 

How do you create a dynamic print range to accept new data as new dat are
being added in new rows?

Making print range dynamic in macro
 

If and when possible print the entire sheet
or a specified nr of columns (e.g. A:F)

(excel will skip anything beyond the usedrange)

else define a "dynamic range".. e.g.
MyDB = =Offset($D$10,0,0,counta($D$10:$D$65536),counta($1 0:$10))

then via define names set the Print_Area (localized) to point to MyDB



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Newbie dumbo wrote :

How do you create a dynamic print range to accept new data as new dat
are being added in new rows?