y = ActiveCell.Value

will place the value of the active cell in y

y = ActiveCell.Address

will place the address of the active cell in y

--
Regards,
Tom Ogilvy


"hemants" wrote in message
...

Hello

I am trying to figure out the command on how to pull up the cell range
value

Example:
Say "ActiveCell" is currently on "A1"
how do i make 'y = A1' but by using ActiveCell
i.e.: y = ActiveCell.Value


--
hemants
------------------------------------------------------------------------
hemants's Profile:
http://www.excelforum.com/member.php...o&userid=15031
View this thread: http://www.excelforum.com/showthread...hreadid=266457