changing range reference

[Guest]

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

 

[Don Guillett]

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

--
Don Guillett
SalesAid Software
(e-mail address removed)

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

 

[Tom Ogilvy]

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

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

 

[Guest]

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