Problems with Offset 1

[shelby55]

Hi

I'm using Excel 2003.

I have a worksheet that I use as "raw data" to populate other worksheets. I have the raw data as a named range using:

 =OFFSET(RawData!$A$1,0,0,COUNTA(RawData!$A:$A),COUNTA(RawData!$2:$2))

I inserted a column between existing columns at G (columns are now from A to P) and I thought this wouldn't affect the named range but it does in that the column of P isn't included in the named range anymore and I can't seem to figure out how to add it.

What am I doing wrong? Thanks.

 

[Lilliabeth]

put some text in G2

--Lilliabeth

 

[shelby55]

You are so smart!! I thought if I just put the header name it would be alright but it needed data.

Thanks so much!!