| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with link to named range | Excel Discussion (Misc queries) | |||
| Series Named Range Problem | Charts and Charting in Excel | |||
| Problem with creating a named range | Excel Programming | |||
| external named range problem | Excel Discussion (Misc queries) | |||
| named range problem | Excel Programming | |||
Threaded Mode
