access to cell values

[bbxrider]

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

 

[bbxrider]

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'
???