Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check cells in a range for a value
I have written a macro that compares one set of values with another. 99% of
the time, the cells in the results table are 0. Instead of keeping the workbook open just so I can make sure all the cells in the range are indeed 0, can I add this check to my macro so that a message box pops up only if one of the cells has a value 5 otherwise close the workbook. I know I can check cell by cell using a loop, but I'd rather use some sort of Range syntax to check it all in one fell swoop. Thanks, Barry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check cells in a range for a value
You can check it like this
If Application.WorksheetFunction.CountIf(Range("a1:a1 0"), "5") < 0 Then -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "BCS" wrote in message ... I have written a macro that compares one set of values with another. 99% of the time, the cells in the results table are 0. Instead of keeping the workbook open just so I can make sure all the cells in the range are indeed 0, can I add this check to my macro so that a message box pops up only if one of the cells has a value 5 otherwise close the workbook. I know I can check cell by cell using a loop, but I'd rather use some sort of Range syntax to check it all in one fell swoop. Thanks, Barry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to check if the values in a range of cells are greater than 0 | Excel Worksheet Functions | |||
Check text in range of cells | Excel Discussion (Misc queries) | |||
How do I write formula to check a range of cells? | Excel Worksheet Functions | |||
check for FALSE values in a range of cells in VBA | Excel Discussion (Misc queries) | |||
How do I get Excel to display a range of cells with a check box? | Excel Discussion (Misc queries) |