Maybe..

I noticed that you have spaces in (and after! the Sheet names..
maybe it helps if you put SingleQuotes ' = chr(39) around the sheetnames
for your references.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(EC) wrote:

Hello Dave,

Thanks for your post.

and .name code).

Sheets("Inquiry Form ").Rows.("1:100").Copy
Sheets("NewInquiryForm").Activate
Range("A1").Select
ActiveSheet.Paste

Next, I created a new workbook (manually) with three worksheets. One
snip