Modify this code to paste special, values

  • Thread starter Thread starter Jonsson
  • Start date Start date
J

Jonsson

Hi All,

I need to modify this code to paste only values.

Sheets("1").Range("b4:d33").Copy ActiveSheet.Range("b4:d33")

Any idea's?

//Thoma
 
Sheets("1").Range("b4:d33").copy
ActiveSheet.Range("b4.d33").PasteSpecial Paste:=xlValues
 
Hi Jonsson

One way

Range("b4:d33").Value = Sheets("1").Range("b4:d33").Value
 
ActiveSheet.Range("b4:d33").Value = _
Sheets("1").Range("b4:d33").Value
 
Hi, Ron and Tom

Thanks for your answers. The modification works great.

Thank you so much!

//Thoma
 
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 Special Values 3
VBA 2 Codes 2
Clear Check Box 2
Paste copied data to specified sheet based on range - variable iss 6
Run-time error 1004 paste method of worksheet class failed 3
Solver Macro 2
Run macro on selected sheets 10
Selecting 10 charcters on one cell and pasting to another cell 10

Back
Top