LinkBack URL
About LinkBacks
Dear All,
After lots of help yesterday from RoyUK, I now have the following macro. However, this gives me a compile error Block if without End If but I do have an End If statement.
Any ideas?
Please Login or Register to view this content.
Thanks
DB
Dear All,
After lots of help yesterday from RoyUK, I now have the following macro. However, this gives me a compile error Block if without End If but I do have an End If statement.
Any ideas?Please Login or Register to view this content.
Thanks
DB
For each "If" in your code you need an "End If". Having one at the end will not suffice, alas.
Thank you!
It would be something that simple!!
my macro now works beautifully so thank you very much!
May want to note:
Sometimes you will get a "NEXT with no FOR" error, when in fact it's an ENDIF that you're missing.
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Dumb Blonde
Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks