![]() |
|
#1
|
|||
|
|||
![]()
I previously created a spreadsheet in Excel 2010 that allowed me create a default range for printing. This range grew as I added new rows of data into the spreadsheet so that each time I added new data and clicked the print icon, only rows through the last row plus one additional blank row are printed. Unfortunately, I cannot figure out how I created this dynamic range. Any help would be appreciated.
|
#2
|
|||
|
|||
![]()
Maybe formatting the data as a TABLE? Then the print range would reflect the table, rather than cell references.
|
![]() |
Tags |
dynamic print range |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
AustinBrister | Word VBA | 19 | 08-22-2016 05:18 PM |
![]() |
sryder | Excel | 5 | 04-07-2016 03:37 PM |
![]() |
Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
Retrieving data from data base based on text selection | capitala | PowerPoint | 0 | 12-10-2014 08:10 AM |
![]() |
expert4knowledge | Excel | 2 | 09-09-2014 06:27 AM |