pastespecial question
 

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

pastespecial question
 

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

pastespecial question
 

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

pastespecial question
 

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

pastespecial question
 

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

pastespecial question
 

do two .pastespecial's right in a row.

something.copy
someotherrange.pastespecial paste:=xlpastevalues
someotherrange.pastespecial paste:=xlpasteformats

Or some combination of what you need.

Gary Keramidas wrote:

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

--

Dave Peterson

pastespecial question
 

that's what i ended up doing, just wondered if there was another way.

thanks for confirming

--


Gary


"Dave Peterson" wrote in message
...
do two .pastespecial's right in a row.

something.copy
someotherrange.pastespecial paste:=xlpastevalues
someotherrange.pastespecial paste:=xlpasteformats

Or some combination of what you need.

Gary Keramidas wrote:

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

--

Dave Peterson