changing range reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Have you tried absolute references to lock it
$a$1 will stay as a1

--
Don Guillett
SalesAid Software
(e-mail address removed)
Lawlera said:
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
Click to expand...
syntax for reading the cell using
 
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 said:
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
Click to expand...
syntax for reading the cell using
 
Back
Top