Take a look at the object browser in Excel. It contains full doc on every method you're trying to use via Win32::OLE Alt-F11 and then F2 while in Excel should bring up the object browser. Take a look around and get familiar with its object structure if you plan on doing any serious OLE programming at all. Sample code is nice and all, but copying and pasting someone else's code does not a learning experience make. However I would suggest looking at the Range object once you have Excel's object browser open. It should contain the tools you're searching for.