| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste special
I'm trying to copy a cell and paste it back in the same cell just as
values...is this possible. I'm doing the following code: ThisWorkbook.Worksheets("Shapes").Cells(1, 8).copy ThisWorkbook.Worksheets("Shapes").Cells(1, 8).PasteSpecial Paste:=xlPasteValues |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste special
This works:
Sub pastespecail() With ThisWorkbook.Worksheets("Shapes").Cells(1, 8) .Copy .pastespecial Paste:=xlPasteValues End With End Sub -- Gary''s Student - gsnu2007k " wrote: I'm trying to copy a cell and paste it back in the same cell just as values...is this possible. I'm doing the following code: ThisWorkbook.Worksheets("Shapes").Cells(1, 8).copy ThisWorkbook.Worksheets("Shapes").Cells(1, 8).PasteSpecial Paste:=xlPasteValues |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
| Automating copy/paste/paste special when row references change | Excel Programming | |||
| 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
