Solved: .Copy Destination (Error)

[parttime_guy]

Dear All,

I am getting an error in the line below

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

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

Kindly help

Thanks n Best Regards

[jolivanes]

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]

Hi John,

Sorry - for the delay was not in town.

Checked your code - it worked.

Thanks for your help - Best regards