Hmm... I just noticed you are using the previous version - so i'm assuming you can't open what i attached. if you can open it, just use that.
Also, when i pasted in that code the first time one important line got "commented out" -- copy the code from my edited post (below pasted again).
To make a macro in excel '03,
1.On the Tools menu in Microsoft Excel, point to Macro, and then click Visual Basic Editor.
2.On the Insert menu, click Module.
3.Type or copy your code into the code window of the module.
4.If you want to run the macro (macro: An action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) from the module window, press F5.
5.When you're finished writing your macro, click Close and Return to Microsoft Excel on the File menu.
Bookmarks