Hi
use
target.value


--
Regards
Frank Kabel
Frankfurt, Germany

"msnews" schrieb im Newsbeitrag
...
excel 2000
i changed some code to use cell names instead of references, which
works,
but can't get access to the cell values

original code using cell references:
Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$O$21", "$O$22", "$E$7"
targetVariable = ActiveSheet.Range("o$22").Value

new code to accomodate using cell names:
Sub Worksheet_Change(ByVal Target As Excel.Range)
Select Case Target.Name.Name
Case "stock_price", "xAxisMax"
targetVariable = ActiveSheet.Range("xAxisMax").Value
...... target variable doesn't get populated but no error msg

seems the 'activeSheetRange...' reference doesn't work due to
changing the
'target as range' to 'target as excel.range' - i have some other ways
to get
the
cell values but nothing seems to work, i'm stumped