Solved: intersection of named range and a column

[drawworkhome]

hello,
is there a way to find the address of the intersection of a named range (rows) and a column? i have a named range "test" that is two rows. i would like to find the cell address of the intersection of the two.

thank you!

[Bob Phillips]

MsgBox Intersect(Range("range_Name"), Columns(5)).Address

[drawworkhome]

thank you, most appreciated.

[Zack Barresse]

If that works for you, please mark your thread as Solved from the Thread Tools menu. :)