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?

 

[Magic Polygon]

Thanks, I needed something like this. I find the Office VBA reference confusing sometimes, I can't always find what I'm looking for there.

 

[MARK858]

Thanks, I needed something like this. I find the Office VBA reference confusing sometimes, I can't always find what I'm looking for there.

You're not the only one

 

[duggie33]

I am one of them. Chip Pearson is a legend. RIP Chip.

 

[MARK858]

I am one of them. Chip Pearson is a legend. RIP Chip.

He is but that particular article was written by Alan Beban, who allowed Chip to repost it for future reference.