How I can to obtain intersection cell ?

[zigraj]

In Range("B1") I have "TEST1" in Range("A6") I have "TEST2"
in intersection range range("B6") I have "TEST3".
How I can to obtain this value "TEST3" ?

[TheFIDDLER]

You might be able to use the range intersect function in excel.

Not exactly sure how you have your data set up but I will assume a standard 2 x 2 grid.

Enter the following in an excel cell
+B1:B6 A6:H6

Result will be the value in the intersecting or overlapping range area. If you use named ranges, this gets really interesting as you can ask for the intersect of ie: +Sales July

The space between the two ranges indicates that you are looking for an intersecting value.

Also, the excel functions of Vlookup and Hlookup can be used for what you are asking for. VBA can access any of these builtin functions.