PDA

View Full Version : Solved: .Copy Destination (Error)



parttime_guy
04-27-2010, 07:17 PM
Dear All,

I am getting an error in the line below

Sheet2.Range("B2").Range(Selection, Selection.End(xlDown)).Copy Destination:=Sheet3.Range("B3")

Also, how do give the actual name of the sheet - instead of Sheet2/Sheet3 etc.

Kindly help

Thanks n Best Regards

jolivanes
04-27-2010, 10:10 PM
This should work for the copy and paste part



Sheets("Sheet1").Range("B2", Range("B" & Rows.Count).End(xlUp)).Copy Destination:=Sheets("Sheet2").Range("C6")



HTH
John

parttime_guy
04-29-2010, 07:15 PM
Hi John,

Sorry - for the delay was not in town.

Checked your code - it worked.

Thanks for your help - Best regards