Dynamic Range & Offset code problem

  • Thread starter Thread starter JoAnn
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Range maker code 9
Multiple Dynamic Named Ranges across Columns 3
How I can set dynamic pivot table ONLY when I have enough data point 1
Trouble with dynamic named range 4
Post my named ranges in column A 10
Excel 2007 dynamic chart range correction 11
Dynamic Name Range using VBA 1
Dynamic range issue 5

Back
Top