Basically I want the code to start by looking in the sheet "dump" for the string "Check Figure". If the string exists, then it displays a message then ends the macro. If the value does not exist, then just continue running the macro. This should be very simple but I'm drawing a blank. Here is what I have so far.
Please Login or Register to view this content.
Last edited by mvparker79; 07-02-2014 at 10:41 AM.
No need for else
Please Login or Register to view this content.
It is still giving me the error "Object variable or With block variable not set"
Much better
Please Login or Register to view this content.
Sorry, when I remove the string "Check Figure", THAT is when it gives me that error.
Change this line
Please Login or Register to view this content.
BOOYA! You rock AB33! Thanks a million. I knew it should be easy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks