| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing range reference
I have several sheets reading the value from a single cell.
Trouble is that is a row or column is inserted all the referencing is thrown out the window Naming the cell seems to be the answer but having difficulty with the syntax for reading the cell using ' reference:-"cellname" Grateful for any ideas that don't include goto or select TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing absolute reference for range of cells | Excel Worksheet Functions | |||
| Copying a named range with a changing cell reference | New Users to Excel | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Reference a changing range | Excel Worksheet Functions | |||
| Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
Threaded Mode
