| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dymanic Range Names
Is the sheet named Sheet1?
In the InsertNameDefine dialog box, select the range name in the list. Click in the Refers To box What is selected on the worksheet? dee wrote: I seem to be missing something regarding named ranges. I have entered data in column A, inserted a name that refers to: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1) But when I add data to the end of the column, the range doesn't expand. Help! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a dymanic formula to a cell using visual basic | Excel Discussion (Misc queries) | |||
| Adding a dymanic formula to a cell using visual basic | Excel Discussion (Misc queries) | |||
| Range Names | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| Plot a line? Set dymanic axis Max min | Charts and Charting in Excel | |||
Threaded Mode
