-
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.
Delete entire row based on one cell? :(
- Thread starter jayson26
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,082
- Office Version
- 365
- Platform
- Windows
Yes. Would you like to do this via VBA or using Filters? What does your data look like, i.e. is their some column which will always have data in it even though column A is blank, or are you just looking to delete blank rows?
Upvote
0
I have a spreadsheet which has data in Columns A through F.
Most rows have data in every cell (i.e.: A2, B2, C2, D2, E2, F2).
Some rows, however, do not have any data in the A cell.
I'd like to delete these entire rows without having to sort the list.
What are your suggestions?
thanks.
Most rows have data in every cell (i.e.: A2, B2, C2, D2, E2, F2).
Some rows, however, do not have any data in the A cell.
I'd like to delete these entire rows without having to sort the list.
What are your suggestions?
thanks.
Upvote
0
DRJ's response is right on. If you want the code, here it is...
Columns("A:A").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
Range("A1").Select
You could also select the entire range and use an autofilter, but that's more work than needed.
K
Columns("A:A").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
Range("A1").Select
You could also select the entire range and use an autofilter, but that's more work than needed.
K
Upvote
0
Similar threads
- Solved
- Solved
