It's not clear to me, what you mean.
B8 and D8 do not intersect!?

Have a look at the Intersect method.
Maybe, that's the one you're after.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

"ibeetb" skrev i en meddelelse
...
Is there a way to get the value of a cell which lies at the intersection
of
say......B8 and D8? (I'd prefer to do in code - but will accept doing it
in
a wrksht function)

Thanks