access to cell values
 

trying to reply to answer to a post from 5/27 but my newsgroup client,
outlook express, is only bring up messages from 5/28/04

this suggestion, me.range("cellName").value does not work, i'm still
trying
see below for original question and suggestion

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

access to cell values
 

oops, sorry that works, my mistake, had the cellName i was trying to access
spelled wrong, duh,
so imagine when 'range' is used with no qualifier, it assumes the current
'activesheet'
???

"bbxrider" wrote in message
m...
trying to reply to answer to a post from 5/27 but my newsgroup client,
outlook express, is only bring up messages from 5/28/04

this suggestion, me.range("cellName").value does not work, i'm still
trying
see below for original question and suggestion

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