msgbox sheets("othersheetnamehere").cells(7,2).value


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RSunday" wrote in message
...
Thanks!

And what if the cell is on a different page than the cell making the
reference?
I.e. how do I adress a cell on a specific page?

"Don Guillett" wrote:

msgbox cells(7,2).value

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RSunday" wrote in message
...
How do I get the value of the cell with row = 7 and column = 2 (that
would
be the value of the cell "B2") in VBA?

I have made a function where I calculate which cell is holding the
relevant
data - and now I just want to get to that data once I know the row and
column
of the cell.

And how if the cell is on a different page in my spreadsheet?