Thanks for your reply. That is very helpful

Is there a way to have it start with the final sheet on the right an
work its way back to the first sheet (all the way to the left).

Also, how can I save this macro in Excel. I am new to macros - I hav
saved a few in Word. But I wasn't successful with Excel.

To run your macro, I went to Tools- Macros - Visual Basic Editor, the
I went to insert Module, copied your code and hit run. Is this th
easiest way to run a macro and if so - how do I save the macro fo
future use.

I appreciate your help very much. Thank yo

--
Message posted from http://www.ExcelForum.com