copy frm range to range 1

[max1565]

I am trying to copy one range to another, but I keep getting the following message "object doesn't support this method or property".

Can someone tell me what i am doing wrong?

Thanks

Sub Extract_RCRdata() 'extracts RCRdata for month/year specified
Range("commercial&quot.CopyTorange ("RCR_out&quot, _
Unique:=False
Application.Goto Reference:="R1C1"
End Sub

 

[Bowers74]

Sub Extract_RCRdata() 'extracts RCRdata for month/year specified
Range("commercial&quot.Copy Destination:=Range("RCR_out&quot
Range("A1&quot.Select
End Sub

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!