You're welcome.Could you please indicate precisely how many rows you have.Open Tools/Macro/Macros.Give a name and click on Create.You'll see a new window.You have just to paste the code between Sub "The name of your macro"() and End Sub.Close the window.To execute the macro, open Tools/Macro/Macros/Select your macro and click on Execute or double-click on the name.Originally Posted by outthere
Bookmarks