MACRE0

Try

Application.CalculateFull

In place of sh.calculate

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"MACRE0" wrote in
message ...

While that's exactly the type of thing that I'm looking for, it doens't
seem to work in this case. If you'd be willing, I'd happily send you
the speadsheet so you can see exactly what I mean about excel not
caculating the tab until some other action is performed.


--
MACRE0
------------------------------------------------------------------------
MACRE0's Profile:
http://www.excelforum.com/member.php...o&userid=10848
View this thread: http://www.excelforum.com/showthread...hreadid=478527