myVar = Activecell

but no need to select it

myVar = Range("A1").Value

--
HTH

Bob Phillips

"ajocius" wrote in
message ...

Group,
After I select a cell how do I assign the contents of the cell
into a variable? Seems trivial, but it has me stuck.

Learning VBA and loving it........

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=390560