| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste special
I have this code:
..Range("J" & cnt).Copy Sheets("results").Range("J" & cnt) What is the proper syntax to add on the end to do a paste special values only? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste special
Why copy paste? This will work...
Sheets("results").Range("J" & cnt).value = .Range("J" & cnt).value But if you want to then ..Range("J" & cnt).Copy Sheets("results").Range("J" & cnt).PasteSpecial(xlValues) application.cutcopymode = false -- HTH... Jim Thomlinson "Mona" wrote: I have this code: .Range("J" & cnt).Copy Sheets("results").Range("J" & cnt) What is the proper syntax to add on the end to do a paste special values only? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste special
Hi Again :)
..Range("J" & cnt).Copy Sheets("results").Range("J" & cnt) .PasteSpecial (xlPasteValues) Charles Mona wrote: I have this code: .Range("J" & cnt).Copy Sheets("results").Range("J" & cnt) What is the proper syntax to add on the end to do a paste special values only? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| How do I capture user paste action and convert to Paste Special | Excel Programming | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Linear Mode
