View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default Save One sheet

You don't need to do all of that work to "find" it. It's the active workbook
at this point, as Chip Pearson points out in his reply.


On Fri, 18 Feb 2005 13:40:25 -0600, "George Nicholson"
wrote:

(If you use this method without specifying a Before or After argument, the
sheet will be copied to a new 1-sheet workbook. Now you have to find that
new workbook in order to save it.