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.

Dynamic Range & Offset code problem
 

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JoAnn" wrote in message
...
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.

Dynamic Range & Offset code problem
 

You're an angel!!! Many, many thanks ... this was driving me crazy!
--
JoAnn


"Don Guillett" wrote:

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JoAnn" wrote in message
...
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.

Dynamic Range & Offset code problem
 

You musta seen my wings.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JoAnn" wrote in message
...
You're an angel!!! Many, many thanks ... this was driving me crazy!
--
JoAnn


"Don Guillett" wrote:

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JoAnn" wrote in message
...
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.