"GS" wrote in message
...


I'm curious as to why you'd invoke the dialogs to move/copy when using
the Move/Copy methods accept optional Before/After parameters to
specify destination (within same wkb or other open wkb). If these
parameters are omitted then a new wkb is created with just the
moved/copied sheet[s].



The macro is for my use, not for distribution. There are several
possible destination workbooks, and it seemed easier to use the built-in
dialog than to devise code to determine the destination workbook.

I guess I could use the file picker dialog .. then I wouldn't have to
remember to open the destination workbook before launching the macro
<g.


--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)