[Jay59]

I have a code to copy a worksheet and create and new file with it, then email it.

This way copies the formulas, is there a way to just copy the data, kinda like a paste specials with values not formulas?

TIA

[shades]

Howdy. Try the macro recorder, and selecting the entire worksheet, then in the new worksheet/workbook, select cell A1 and Paste Special. See what code you get and modify for general use.

[Jay59]

Thanks, found a work around doing what you said.