Dynamic print range problem

[Chris Davison]

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

 

[Chris Davison]

thanks Aladin, as always, your input is appreciated

I probably didn't make it clear my range was expanding per column A and row 1.

take care
Chris