Try opening Excel, turn the macro recorder on, perform the operations that you wish to do. When you are done turn the macro recorder off and view the macro with the VBA Editor. Copy the macro into a text file and compare the VB commands with what you have put in your code.