For example suppose I want the variable columns hold the values "10 OR 15 OR 18" then simplify this by saying:
Please Login or Register to view this content.
So I am testing a If the current cell is blank AND the column number is either 10, 15 or 18.
How can this be done? In a previous post I saw something about splitting an array or a function called Split or something like that. Could that be it?
Last edited by Excel_vba; 12-26-2013 at 10:17 PM. Reason: tags around code
If I get what you mean..
Please Login or Register to view this content.
Yes I know about the OR function but I have another case where I need to list 1,3,6,7,8 or 9. That would get quite long and I'm trying to find a way to simply things. Is there another way?Originally Posted by millz
If I get what you mean..
Please Login or Register to view this content.
You can use the Select Case statement.
Please Login or Register to view this content.
I really can't see that working, even using Split.
"10 OR 15 OR 18" is a string and would always be seen as TRUE in the if statement.
If you split it, using space as a delimiter, you would end up with an array of strings - "10", "OR", "15", "OR", "18".
If posting code please use code tags, see here.
See
Please Login or Register to view this content.Please Login or Register to view this content.
jindon
Won't that check if the value in Cells(currentRow, columnNo) equals 10, 15 or 18?
Ahhh...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks