Chris Davison
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 1,790
Evening all,
I've set up a dynamic named range which expands and contracts as rows and columns are added or deleted and called the range "test"
if I use "test" in the print range box of page setup it retains the original size of the range when it was entered....
ie when the range contracts, it still prints the blank rows, keeping the original reference A1:G400 rather than "=test"
am I missing something ? I want the print range to expand and contract accordingly.
many thanks
Chris
I've set up a dynamic named range which expands and contracts as rows and columns are added or deleted and called the range "test"
if I use "test" in the print range box of page setup it retains the original size of the range when it was entered....
ie when the range contracts, it still prints the blank rows, keeping the original reference A1:G400 rather than "=test"
am I missing something ? I want the print range to expand and contract accordingly.
many thanks
Chris