Display cell reference - runtime error type mismatch

[Brumbot]

Hi all,

Just a quick one (hopefully). Can anyone tell me why I get a mismatch out of this? I'm trying to display the value at the co-ordinates rng1,rng2.

Please Login or Register  to view this content.

Thanks.

[Norie]

rng1 and rng2 are ranges not coordinates.

Are you actually trying to find where they intersect?

Please Login or Register  to view this content.

[Brumbot]

Hi Norie,

That's what I thought. That works great, thankyou!

[Cheeky Charlie]

Following Norie's prompt, have a look at this - the important point is that the row and column of the two found entries are used as coordinates for the output.

Please Login or Register  to view this content.