Would this alternative approach achieve the same ends: Save spsht1 as spsht2
and hide the columns that are not required. If so, why not create two macros
and use one spreadsheet only. One macro hides the unwanted columns, and the
macro restores them.
Have I missed something, or have you not told me something?
Search the web and raise money for charity at http://www.yqcomputer.com/