Stepping outside the range of a cell

[Magic Polygon]

Suppose you have have a cell:

Set FirstCell = Range("B4")

and this reference:

FirstCell (4, 6)

What does the reference reference?

 

[Ruddles]

Four down and six along? Simple enough to test.

 

[duggie33]

Odd question...cell G7

 

[Magic Polygon]

My apologies, I didn't this was easy. What is a good way to test?

 

[duggie33]

Sub MagicPolygon()

    Dim FirstCell As Range

    Set FirstCell = Sheet1.Range("B4")

    FirstCell(4, 6) = 1

End Sub

 

[Magic Polygon]

Would the best way to run this be by attaching it to a button?

 

[duggie33]

You could put the Sub code in a Module and, with your cursor in the Sub, hit F5 to run it. The number "1" will appear in cell G7. A button would work too...

 

[Magic Polygon]

Ah, I see. Thank you very much.

 

[Magic Polygon]

FirstCell (1, 1) references FirstCell.

 

[MARK858]

Have a read of the link below where there is an explanation

Cells Within Ranges