Automation for Copy and Paste Special

[imran khan]

Hi,

I tried alot but could not do the following:

i have data in the range M11:O1844. I want that by a click of a button, all the data in the range M11:O1844 is copied and paste special in the range G11:I1844.

How can this be acieive by VBA. Please define steps also to run as whenever i tried, it give me an error.

Appreciating your support. Thanks

 

[Pavan.Sada.PS]

Range("M11", "O1844").Select
Selection.Copy

Range("G11").Select
Selection.PasteSpecial Paste:=xlPasteValues

 

[Smallman]

This should go OK too.

Sub PasteVals()
    [G11:I1844] = [M11:O1844].Value
End Sub

Take care

Smallman