I have ran into this problem a few times and still don't understand why it happens. When I use For Each x then later say Next, it comes back with an error saying invalid use of Next. Could someone help me and explain how to use Next so I can stop running into this problem?
Please Login or Register to view this content.
I don't know if other programming languages allow for multiple loops/counter variables in a single Next statement, but I believe that VBA does not allow this. You need a separate Next statement for each loop.Please Login or Register to view this content.
Originally Posted by shg
I've tried that as well and it still shows the same error, If it's before the End If or after the End If it still has problems
The Next statements should be outside of the block If (after the End If). Can you post an example you have tried with the three Next statements outside of the block If? It should work, unless there is something else I am missing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks