ok, i need cell formats, colors. borders , etc.


--


Gary


"Dave Peterson" wrote in message
...
I think Bob meant to say xl2002 or higher.



Gary Keramidas wrote:

xl2003, bob.

so is this the best wat with xl2003?

--

Gary

"Bob Phillips" wrote in message
...
If you have XL2002 there is an xlPasteValuesAndNumberFormats constant
that
you can use.

--
HTH

Bob Phillips

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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






--

Dave Peterson