VBA Macro Help
 

Hello

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

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

--
hemant
-----------------------------------------------------------------------
hemants's Profile: http://www.excelforum.com/member.php...fo&userid=1503
View this thread: http://www.excelforum.com/showthread.php?threadid=26645

VBA Macro Help
 

how about activecell.address
or activecell.column or activecell.row


--
Don Guillett
SalesAid Software

"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

VBA Macro Help
 

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