Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Dynamic Range | Excel Discussion (Misc queries) | |||
Macro print range not dynamic like I wanted it to be | Excel Worksheet Functions | |||
Macro to print a dynamic range | Excel Programming | |||
making autofill range dynamic | Excel Programming | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming |