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.
|