i want to paste values and formats, this option seems to be missing.

so, i if use this to copy the values
Workbooks(CurBook).Worksheets("sheet1").Range("c" & firstrow).PasteSpecial
xlValues
and then run this right after
Workbooks(CurBook).Worksheets("sheet1").Range("c" & firstrow).PasteSpecial
xlFormats

it seems to work, but also seems to slow things down a little.
i realize i could copy the values and then reformat the sheet, but ti seems
like a waste.

is there another way to combine the 2 options i want?



--


Gary