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

changing range reference
 

Have you tried absolute references to lock it
$a$1 will stay as a1

--
Don Guillett
SalesAid Software

"Lawlera" wrote in message
...
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

changing range reference
 

Range("A1").Value = Range("CellName").Value

If done in a sheet module and cellname is on another sheet you need to
include the sheet name

Range("A1").Value = Worksheets("SheetOther").Range("CellName").Value

for a formula

=CellName



--
Regards,
Tom Ogilvy

"Lawlera" wrote in message
...
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

changing range reference
 

Thanks Tom - mind block - didn't guess it would be that simple!