Named Range Problem
 

I have set up a Named Range called OHAC and used the following formula:
=OFFSET(Sheet1!$A$37,0,0,COUNTA(Sheet1!$A$37:$A$46 ),1)
There are text names in cells A37:A46. When I use =counta(ohac) I get the
number 1 and a save window comes up with the header Update Values: Sheet1.
What am I doing wrong?
I would also like to get the physical row number of the last row number as
the range changes as I add rows.
Thanks!

Named Range Problem
 

1.Your defined name should work. Are you sure you used absolutes?
in the NAME box type in ohac to see what you get

2. =match("zzzzzzzz",ohac)+36
--
Don Guillett
SalesAid Software

"David" wrote in message
...
I have set up a Named Range called OHAC and used the following formula:
=OFFSET(Sheet1!$A$37,0,0,COUNTA(Sheet1!$A$37:$A$46 ),1)
There are text names in cells A37:A46. When I use =counta(ohac) I get the
number 1 and a save window comes up with the header Update Values: Sheet1.
What am I doing wrong?
I would also like to get the physical row number of the last row number as
the range changes as I add rows.
Thanks!

Named Range Problem
 

I took your example from your post to my other problem (Range Formula
Problem) and changed the 1 at the end to -1 and it works now. Thanks!

"Don Guillett" wrote:

1.Your defined name should work. Are you sure you used absolutes?
in the NAME box type in ohac to see what you get

2. =match("zzzzzzzz",ohac)+36
--
Don Guillett
SalesAid Software

"David" wrote in message
...
I have set up a Named Range called OHAC and used the following formula:
=OFFSET(Sheet1!$A$37,0,0,COUNTA(Sheet1!$A$37:$A$46 ),1)
There are text names in cells A37:A46. When I use =counta(ohac) I get the
number 1 and a save window comes up with the header Update Values: Sheet1.
What am I doing wrong?
I would also like to get the physical row number of the last row number as
the range changes as I add rows.
Thanks!