Also see Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks) for whenever you see things that Excel lets you do manually but where you encounter problems reproducing them in code.