I have written the following code to copy data from row 1 to the last row containing data in Cols O, Q:U
However I get application defined or object defined error
sheets(2).Range("O1:O", "Q:U" & LR).Copy Destination:=Sheets(3).Range("A1")
It would be appreciated if someone could kindly...