Ending Loop

[tcnt9176]

Ok. This is my 2nd time to ask about ending a loop. I got help with the 1st & it works great!! I tried using the template of that one to make my next one work without success. The macro repeats the same action on multiple worksheets and I need it to stop and go to the next step when there are no other sheets. Here is what I currently have.

Application.ScreenUpdating = False
Do
If Not ActiveSheet.Next.Select Is Nothing Then----This doesn’t work.
Cells.Select
Selection.Copy
ActiveSheet.Next.Select
X
X
X
X
X
Else
Exit Do
End If
Loop
Application.ScreenUpdating = True

 

[erik.van.geit]

Is there a course that I could take or a book you recommend to learn the basics.

I've never read a book, just one very quickly and partially some time ago

for me the best book is...
the helpfiles

and the greatest resource...
this forum

you can do a search (see link top of page) for
book recommend vba
check
"Search for all terms"

I tested this and it provides some useful links (at least the titles are promissing)

see also
http://www.mrexcel.com/board2/viewtopic.php?t=277808

 

[tcnt9176]

HOORAY!!! Thanks to both of you for your help. I incorporated both of your codes into one to make it work for me and it works great!! Thanks for all of your help and to VoG for your patience!!! Have a great day!!
Chris