in reply to Formula copy in Win32::OLE
Also see Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks) for tips on how to automate automating Excel.