aayaanmayank
Board Regular
- Joined
- Jul 20, 2018
- Messages
- 157
Hi Can someone help me with the code that if cell is blank then remove color from the entire column in one go.
On Error Resume Next
Range("A2:N24").SpecialCells(xlCellTypeBlanks).EntireColumn.Interior.Color = xlNone
On Error GoTo 0
That means your cells are not blank, rather, they have formulas in them that are displaying the empty text string (""), correct? If so, what kind of values are in the cells that are not "blank"... numbers, text or a combination of numbers and text?Sorry Richard but this is remove color from entire column however what i need of cell is not blank then it should not remove color.
I'm sorry, I mistook who you were answering (my fault, not yours).Hey Rick i am sure that there is no formula, cells may contains text, Numeric digit or combination of both
I'm sorry, I mistook who you were answering (my fault, not yours).
Try the code davesexcel posted in Message #2 .
Hi Rick yes i tried that one also but no luck.