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

Only the first time, Bob.

Almost never for subsequent calcs.

In article ,
"Bob Phillips" wrote:

Surely, the active cell is the calling cell?

Of course, not thinking.

--

HTH

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

"JE McGimpsey" wrote in message
...
Only the first time, Bob.

Almost never for subsequent calcs.

In article ,
"Bob Phillips" wrote:

Surely, the active cell is the calling cell?