Check to see if a certain cell is empty or blank
Posted by John M. on December 19, 2000 4:20 PM
I wrote a macro to check range("H78:R78") to see if all of them were Blank, if this is true then I want to hide row("77:86")
But if one of the cell contain a value the hide should be false.
I use the following macro.
Dim Cell As Range
For each Cell In Range("H78:R78")
If Cell.value = "" Then
Selection.EntireRow.Hidden = True
Selection.EntireRow.Hidden = False
When I run this it Does not work as I want it to be.
I try some other way and it give me an error message type mistch '13'.
Some body please help me. Thanks