access cell values

[msnews]

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'

 

[Frank Kabel]

Hi
see your other post