View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JoAnn JoAnn is offline
external usenet poster
 
Posts: 78
Default Dynamic Range & Offset code problem

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(DO Cs!$4:$4))

Thanks for your help.