Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"msnews" schrieb im Newsbeitrag
...
for excel 2000

had this code working fine:
Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$O$21", "$O$22", "$E$7"
targetVariable = ActiveSheet.Range("o$22").Value

then changed code to accomodate using cell names to this:
Sub Worksheet_Change(ByVal Target As Excel.Range)
Select Case Target.Name.Name
Case "stock_price", "xAxisMax"
targetVariable = ActiveSheet.Range.("xAxisMax").value
.... the targetVariable doesn't get populated but there is no error
msg

i have tried a bunch of different ways to get the data from the
changed
cells from the worksheet_change/select case combinations but nothing
seems
to work, it seems i need some other code than 'ActiveSheetRange....'
syntax,
it seems to have something to do with changing 'target as range' to
'target
as excel.range'