LeeHitchen
New Member
- Joined
- Mar 20, 2002
- Messages
- 26
Hi all
Bit of a problem i hope someone cn help with.
I want to deleted all rows within a workbook (multi sheets) where column j has no values.
I'm able to do each sheet one by one by Selecting column j then Edit/GoTo/Special/Blanks followed by Edit/Delete/Entire Row. However, I'm sure it would be possible to do all sheets in one hit maybe by using a macro?
Ta
Lee
Bit of a problem i hope someone cn help with.
I want to deleted all rows within a workbook (multi sheets) where column j has no values.
I'm able to do each sheet one by one by Selecting column j then Edit/GoTo/Special/Blanks followed by Edit/Delete/Entire Row. However, I'm sure it would be possible to do all sheets in one hit maybe by using a macro?
Ta
Lee