Hi,

Thanks for that reply.

I've tried many variations of what appear to me to be references that
INDIRECT should accept, but I can't seem to get them to work.

Specifically, I do get INDIRECT to work for 1 cell reference, as in:

INDIRECT("Sheet2!A1")

However, when it comes to trying to use COUNT, no variation I use seems
to work and all give me #REF!

Do you think you could get INDIRECT above to work if it were COUNT(A:A)
instead of merely the cell reference A1?

Any ideas on that would be much appreciated - not sure why the token
hasn't fallen through, yet(!)

Cheers,

-Peter


--
Peter Bernadyne
------------------------------------------------------------------------
Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017
View this thread: http://www.excelforum.com/showthread...hreadid=515892