access to cell values
 

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

access to cell values
 

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

access to cell values
 

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" wrote in message
...
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

access to cell values
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"msnews" schrieb im Newsbeitrag
...
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" wrote in message
...
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