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!