XcelNoobster
New Member
- Joined
- Jun 7, 2022
- Messages
- 40
How would I create a macro that removes all the rows where there is a #NAME? error in Column E?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Remove all rows where #NAME? is present
- Thread starter XcelNoobster
- Start date
Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
If you are happy with non-macro solution then
have a look at this
www.extendoffice.com
have a look at this
How to quickly find and remove all rows with errors in Excel?
The approach (Go To Special) that major of articles provide on web has a fatal flaw, it will remove all rows as long as contain blank cells, including the row that all cells have data but one is blank. Here this article introduce 4 methods for removing blank rows (Go To Special, VBA, helper...
www.extendoffice.com
Upvote
0
XcelNoobster
New Member
- Joined
- Jun 7, 2022
- Messages
- 40
I'm looking for a macro solution.If you are happy with non-macro solution then
have a look at this
How to quickly find and remove all rows with errors in Excel?
The approach (Go To Special) that major of articles provide on web has a fatal flaw, it will remove all rows as long as contain blank cells, including the row that all cells have data but one is blank. Here this article introduce 4 methods for removing blank rows (Go To Special, VBA, helper...
Upvote
0
Similar threads
- Question
- Solved
