ExcelBanter - Select instersection of two ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Select instersection of two ranges (https://www.excelbanter.com/excel-programming/291498-select-instersection-two-ranges.html)

Bert[_3_]

Select instersection of two ranges

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.

Pete McCosh[_5_]

Select instersection of two ranges

Bert,

use the Intersect method to return that:

intersect(Range("RowName",Range("ColName")).addres s

Pete

-----Original Message-----
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.
.

All times are GMT +1. The time now is 11:12 PM.