| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pastespecial question | Excel Programming | |||
| PasteSpecial | Excel Programming | |||
| PasteSpecial | Excel Programming | |||
| pastespecial | Excel Programming | |||
| pastespecial on a worksheet question | Excel Programming | |||
Linear Mode
