Select instersection of two ranges

  • Thread starter Thread starter Bert
  • Start date Start date
B

Bert

Hi,

I have two named ranges, one is part of a row and one is a column.
How can I reference the cell where they intersect within VBA code?

Thanks.
 
Bert,

use the Intersect method to return that:

intersect(Range("RowName",Range("ColName")).address

Pete
 
Back
Top