Dynamic Range & Offset code problem

J

JoAnn

I expanded my used spreadsheet area by 1 column but when I go to my dynamic
Used_Data_Range named range it didn't increase. I have no idea what I did
wrong.

Do I have to change the my OFFSET code to fix this? If so, how?

Code being used is:
=OFFSET(DOCs!$A$1,1,0,COUNTA(DOCs!$A:$A),COUNTA(DOCs!$4:$4))

Thanks for your help.
 
D

Don Guillett

In order for the defined named range to expand you needed to put something
in row 4 of that column because you are counting data in that row to
determine the range.
 
Top