Printable View
Hi there,
I am a vba novice but am trying to improve!
I have a spreadsheet with many rows of data. Some of the rows are blank. I would like a macro that would identify the blank rows and fill them with colour - or is this isn't possible, highlight them in another way.
Thanks in advance!
Why not use Format>Conditional Formatting...?
Hi there, welcome to the board!
Can you define a little more what you are trying to accomplish? This might be as easy as Norie states - to use CF. We would still need more definition on what should be highlighted and why though. Is it blank cells in a column of choice? Completely blank rows? Do you have an example you could post?