Exclusion in an array

[mainemojo]

I have the following code to copy some worksheets to a new workbook:

Please Login or Register  to view this content.

How would I modify this so sheet1 is a xlPasteAll instead of an xlPasteValues? I tried copying the For/Next loop, but it just creates another workbook.

[TMS]

Try adding

Please Login or Register  to view this content.

You've already copied Sheet1 so leave it alone.

[jindon]

Please Login or Register  to view this content.

[mainemojo]

Thanks Jindon. Does what I needed and kept the formulas on sheet1, but not the others. Some reason, I keep forgetting about IIF statement!