Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Maybe you're not running the procedure correctly.
ps. with thisworkbook.worksheets("shapes").cells(1,8) .value = .value end with would work as well. But that doesn't address why your code isn't running. wrote: Trying to just copy a cell and paste it back into the same cell but as just the value. It won't do it. It never debugs it just doesn't do it..... ThisWorkbook.Worksheets("Shapes").Cells(1, 8).copy ThisWorkbook.Worksheets("Shapes").Cells(1, 8).PasteSpecial Paste:=xlPasteValues -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
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 | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming |