Hi,
I can make a code which will delete the row if cell is blank. But my requirement is to delete entire row, if each row of E - Z column cell value is blank?
pls advise
On Error Resume Next Columns("E:Z").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks