Hi Friends,
I tried the belwo code to stop Macro if column "A" has the value "#NA" but i am getting error.
{if the Value "#NA" not in the column "A" then macro can continue to run}
Kindly help to recitify the error.
Please Login or Register to view this content.
Would this work?
Please Login or Register to view this content.
Last edited by jolivanes; 04-27-2014 at 11:01 AM.
This code should work,
Regards.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
jolivanes' Code could also work like this;
Please Login or Register to view this content.
Hi, prabhubox@yahoo.com,
is it really #NA thatīs in the area?
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
@ HaHoBe,
Hello Holger,
Maybe with your code like this?
You always seem to come up with much better Code, and I think we should ban you from this Forum, just for that.LOLPlease Login or Register to view this content.
Kind Regards my Friend!
Hi, Winon,
we would need to know if itīs an error returned from a function or a hard-coded value we are searching - code is okay for hard-coded values but Iīm afraid will not work on formulas where you would need to use a loop (according to the tiny bit of information provided: the code only).
Ciao,
Holger
Hi Holger,
Thanks for the feedback.
You really are on your toes today, and very alert!
It is a very valid point you are making, but I am pretty sure it relates to a Function error, and not hard coding.
I guess we will have to wait for more clarification on this.
Ciao
Hi, prabhubox,
if itīs a formula/function you may try the following code
Ciao,Please Login or Register to view this content.
Holger
@ HaHoBe,
Hello Holger,
Wow!, What can I say?, but BRILLIANT!
I "Hate" you
Well done Friend!
Kind regards.
Hello prabhubox,
Would you mind telling us which of the many solutions offered to you, solved your issue?
It would also be good to know if you had an issue with #NA or #N/A.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks