paste special

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Hi Again :)

..Range("J" & cnt).Copy
Sheets("results").Range("J" & cnt) .PasteSpecial (xlPasteValues)

Charles
 

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

Find the correct sheet then find a value on that sheet 8
Make VBA ComboBox_Change work in 3 sheets 1
Public function returns error intermitently 6
Listbox data 8
Get rid of apostrophe when pasting text string values 2
UsedRange.Rows.Count value 5
Help with counting cells in a selected range 2
copy and paste 8

Back
Top