VBA

Moderators: PavlinII
Number of threads: 1673
Number of posts: 3078

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
VBA Stop Cycle Posted by slong on 2 Nov 2012 at 11:01 AM
I have a macro that does everything I need it to do (find a certain word, move the contents of that cell it to another cell, and keep searching for more). However, I can't get it to stop (and move on to the next command).

Here is what I have:

' MOVE "Participant Name"
Columns("C:C").Select
Do
Cells.Find(What:="Participant", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
With ActiveCell
If .Column > 1 And .Row < Rows.Count Then
.Cut Destination:=.Offset(3, -2)
End If
End With
Loop Until IsEmpty(ActiveCell.Offset(0, 1))

I'm sure it's obvious to you gurus, but I need your help!



 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.