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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Something in this is causing a crash 2
What in the edited code below makes it crash????? 2
Copying with .Value 3
Macro to fill to next field with data 4
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Loop to End 0
On error goto specified Line 6
Can Vba workout if a selection is part of a group? 0

Back
Top