After macro
Posted by Graham on February 05, 2002 11:53 AM
After my macro has run how do I get it to fill in the blank cells with a block of colour
Posted by Juan Pablo G. on February 05, 2002 1:01 PM
Not sure what you mean, but try this.
Range("MyRange").SpecialCells(xlCellTypeBlanks).Interior.ColorIndex = 36
Where MyRange is the range you want to check for blanks, can be in the form of A4:G50, or can be a named range (Named MyRange)
Juan Pablo G.
