get value of a known cell
 

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?

get value of a known cell
 

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?

get value of a known cell
 

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?

get value of a known cell
 

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?

get value of a known cell
 

...Thanks again - just found it myself...

Here's a more tricky one:

How do I copy the cell-formatting from one cell to another through VBA?

I have the row and column of both cells - and want one's formatting to be a
copy of the other.

"Don Guillett" wrote:

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?

get value of a known cell
 

The macro recorder is your friend. Record a macro while doing it manually

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RSunday" wrote in message
...
..Thanks again - just found it myself...

Here's a more tricky one:

How do I copy the cell-formatting from one cell to another through VBA?

I have the row and column of both cells - and want one's formatting to be
a
copy of the other.

"Don Guillett" wrote:

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?