paste special

  • Thread starter Thread starter carlos_ray86
  • Start date Start date
C

carlos_ray86

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
 
This works:

Sub pastespecail()
With ThisWorkbook.Worksheets("Shapes").Cells(1, 8)
.Copy
.pastespecial Paste:=xlPasteValues
End With
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

paste value 5
Should I be content with the time code takes? 2
Puzzling printarea code 2
Excel keeps shutting down using code 2
A simple if <> nn then Msgbox "No Match" 5
Select Case Code does not run... 10
Range(sheet2) = Range(sheet1) 11
UnSelect the copied to range after copy... 4

Back
Top