Hi,
I need to see if either of the two numbers exist in a list and if yes, then perform a function accordingly. The exact case is if 0 or "NA" exist in a list in range A1:A20, then I need to print message box with message that "Either of the two numbers exist". Not really sure how to write a small code in visual basic to do this. Any help would be greatly appreciated.
Thanks.
Is the "NA" text or an error result from a formula e.g. #N/A
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Its a text here
Please Login or Register to view this content.
Something like this?
Please Login or Register to view this content.
Last edited by KratjeBier2; 02-06-2014 at 02:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks