I should have said after the "paste" operation.

My apologies.


Gord

On Thu, 20 Aug 2009 19:43:12 -0700 (PDT), c1802362 wrote:

Gord,

with the line of code you suggested, the sheet is created, but no data
is copied to the sheet. I tried it a bunch of ways and its always the
same.

any other suggestions?

Art


On Aug 20, 10:03*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Application.CutCopyMode = False

Place in your code after the copy operation.

Gord Dibben *MS Excel MVP