Deleting rows with no data (in a range)
Closed
Debs269
rizvisa1
- Posts
- 23
- Registration date
- Monday October 15, 2012
- Status
- Member
- Last seen
- August 18, 2016
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Deleting rows with no data (in a range)
- Vba deleting rows that do not contain set values defined in range ✓ - Forum - Excel
- The data transfer rate ranges of wifi - Articles
- How to delete rows with negative values in excel - Forum - Excel
- Visual Basic - Deleting rows in spreadsheet - How-To - Excel
- Delete google play game data - Guide
3 replies
rizvisa1
Jun 17, 2014 at 08:28 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jun 17, 2014 at 08:28 AM
one approach would be to filter the rows using blank as option and delete
In case a row is populated randomly in different cells, you can use COUNTA formula in a cell of a row that is always empty and filter on 0 to filter out rows that have no data in any cell
In case a row is populated randomly in different cells, you can use COUNTA formula in a cell of a row that is always empty and filter on 0 to filter out rows that have no data in any cell
Debs269
Jun 17, 2014 at 10:35 AM
- Posts
- 23
- Registration date
- Monday October 15, 2012
- Status
- Member
- Last seen
- August 18, 2016
Jun 17, 2014 at 10:35 AM
sorry should have written that I need VBA for this to run when input has been completed.
rizvisa1
Jun 17, 2014 at 06:26 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jun 17, 2014 at 06:26 PM
Idea still holds true. If you start macro recorder, perform the action listed and then stop macro, you would have the macro that you seek
