software

Hi, I am stcuk on Excel VB. I am trying to create a macro that when run would
check to see if there is an 'X' in 6 specific cells on a row(the cells are
next to each other), there is an X in all of them it would then display a msg
saying 'not possible', else it would not doing anything. I hope i did pass
the problem across in a sensible manner. Thanks for helping.

I'd just use another cell next to those 6 cells:

=if(countif(a1:f1,quot;xquot;)=6,quot;Not Possiblequot;,quot;quot;)

Format it in a nice big red font.

Jade wrote:
gt;
gt; Hi, I am stcuk on Excel VB. I am trying to create a macro that when run would
gt; check to see if there is an 'X' in 6 specific cells on a row(the cells are
gt; next to each other), there is an X in all of them it would then display a msg
gt; saying 'not possible', else it would not doing anything. I hope i did pass
gt; the problem across in a sensible manner. Thanks for helping.

--

Dave Peterson