John,

Surely, the active cell is the calling cell?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"John H W" wrote in message
...
I know that you can call or find out the the active cell when in a
function/sub, but I can not find out if there is a way to find out the
CALLING cell (without out passing the value as a parameter).

Thanks,
John H W