or

cells(activecell.row,activecell.column)=cells(acti vecell.row,1)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
msgbox cells(activecell.row,1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick S." wrote in message
...
The cell I get information from will always be different, reading
cell.value
from column "A" dependant on cell.address (row) of any other cell.

--
Regards

Rick
XP Pro
Office 2007



"Rick S." wrote:

I am trying to get the value from one cell while in another. If I am at
"C6"
(I have this in a variable) I need to know how to get the value from
"A6".
How do I do this?

--
Regards

Rick
XP Pro
Office 2007