| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create a macro that would check the contents of cells
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i create a macro that would check the contents of cells
I'd just use another cell next to those 6 cells:
=if(countif(a1:f1,"x")=6,"Not Possible","") Format it in a nice big red font. Jade wrote: 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. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
| Macro to create macro | Excel Discussion (Misc queries) | |||
Linear Mode
