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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How can I simply the following, must I keep .Select? (https://www.excelbanter.com/excel-programming/415467-how-can-i-simply-following-must-i-keep-select.html)

Simon[_2_]

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

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

Thanks

Gary Brown[_4_]

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

Cells.Find("latest").Copy Destination:=Cells.Find("latest").Offset(0, 1)
Cells.Find("latest").Clear
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown

"Simon" wrote:

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

Thanks

All times are GMT +1. The time now is 11:12 PM.