How can I simply the following, must I keep .Select?

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

MyWBAccRep.Activate
Cells.Find("latest").Select
Selection.Copy Destination:=ActiveCell.Offset(0, 1)
ActiveCell.Clear

Thanks
 
Cells.Find("latest").Copy Destination:=Cells.Find("latest").Offset(0, 1)
Cells.Find("latest").Clear
 
Back
Top