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.
|