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

's Computer Specifications

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

Thanks

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select 'Sort By' column by simply typing heading letter	dsavant	Microsoft Excel Worksheet Functions	1	24th Mar 2010 08:03 PM
I need help simply	allison	Microsoft Access	1	19th Dec 2006 08:32 PM
Simply C# To VB.net?	Smoke	Microsoft VB .NET	4	18th Jul 2005 05:24 PM
Simply select rows	JP	Microsoft Excel Programming	3	8th Sep 2004 08:58 PM
Simply	Ian	Retailers	3	4th Jul 2004 01:07 AM