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?