Hey all,
I am working on a macro that I can't seem to get to work, seems like something very basic, but I keep getting errors that my End With doesn't have a With, but it does. I read that it can happen because of an unended If statement within the With, but my if statement is matched. Here is that section of code:
I see no problem, but I am a rookie and obviously there is one. Anyone see what I'm doing wrong?
Please Login or Register to view this content.
Last edited by bibleguy125; 02-14-2012 at 01:24 PM.
Block instructions, such as loops, with statements and Ifs are nested and must be closed in the reverse order of opening (i.e. first opened=last closed)
You're getting an error at your End With because you haven't closed your Do Until loop
If you put a 'Loop' on the line between the End If and the End With all should be well.
Oh, I guess I didn't realize a Do needed to be ended. Thanks, I knew I was missing something simple.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks