markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello
I need help with a bit of Macro code. I have managed to figure out most of it by recording and trial and error. The only thing I can't figure out is a line of code that should look down A and any blank cells in column A it deletes the entire row. E.g. A7 might be blank so it deletes the entire row, A9 maybe blank so it deletes the entire row. A11 might be blank so it deletes the entire row. Any blank cells may be shaded but that doesn't matter - if there is not a value in an A cell then it should delete the entire row regardless of whether it is shaded or not.
Thanks
Mark
I need help with a bit of Macro code. I have managed to figure out most of it by recording and trial and error. The only thing I can't figure out is a line of code that should look down A and any blank cells in column A it deletes the entire row. E.g. A7 might be blank so it deletes the entire row, A9 maybe blank so it deletes the entire row. A11 might be blank so it deletes the entire row. Any blank cells may be shaded but that doesn't matter - if there is not a value in an A cell then it should delete the entire row regardless of whether it is shaded or not.
Thanks
Mark
Last edited: