-
Macro for Highlighting Blank Rows
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules