access to cell values

[msnews]

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

 

[Frank Kabel]

Hi
use
target.value

 

[msnews]

hi, thanks for the reply and sorry bout the dble post, i'm getting error
msg's for
posts but sometimes like this they go thru anyway

target.value does work for the the cell that invoked the 'worksheet_change'
however, i need to access the cell values of other cells besides the
invoking target
cell within the 'select case' and can't seem to find the code to get those,
the cells i need to access are always in the active sheet, in this case, its
the most practical
means without having to hard code, i don't mind hard coding the cell names.

i would look like this:
Sub Worksheet_Change(ByVal Target As Excel.Range)
Select Case Target.Name.Name
Case "stock_price", "xAxisMax"
targetVariable1 = something?("xAxisMax").Value
targetVariable2 = something?("stock_Price").Value
targetVariable3 = something?("someOtherCellName").Value

 

[Frank Kabel]

Hi
try for example:
targetVariable2 = Me.Range("A1").Value