get value of a known cell

  • Thread starter Thread starter RSunday
  • Start date Start date
R

RSunday

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?
 
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?
 
...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.
 
The macro recorder is your friend. Record a macro while doing it manually
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
lastrow function help 6
Named cells in an array to a column and to a row 3
VBA set thick borders around non empty cells in range 0
Arrays and scattered cell values or another way? 16
Excel VBA 1
Create if partial match then copy and paste data from one cell to another 1

Back
Top