Hi all,

Does anyone know how to make Excel recalculate the worksheets via VBA?
It can be done in the actual workbook by pressing the F9 key but there
doesn't seem to be a corresponding "recalculate" function in the VBA
section.

It would need to be able to run as part of a macro located in a
standard code module.

Thanks
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=470230