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?