Can someone tell me what is wrong with this code?
Does it have something to do with 2 and statements?
Thank you for your help. I'm trying to learn what I can and when stuff like this happens it drives me nuts... and I can't stop staring at it....and pressing F8!
Please Login or Register to view this content.
If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!
Im not sure what you want.
Here, it goes thru each cell, if all 3 are true then it selects the cell, BUT,
it moves to the NEXT cell,and selects it. So, at most, you will only have 1 cell selected.
Is this what you want?
Or do you want to select ALL cells?
Actually it would be better to COLOR cells rather than select.
once you select the next cell, the prior one turns off. (deselects)
yes - I was using the select to test the code. I have other stuff I'm going to add after I figure out why it keeps giving me an error.
"Object required"
you didnt mention the "Object required" error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks