Deleting rows with no data (in a range)
Closed
Debs269
Posts
21
Registration date
Monday 15 October 2012
Status
Member
Last seen
18 August 2016
-
17 Jun 2014 à 04:14
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Jun 2014 à 18:26
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Jun 2014 à 18:26
Related:
- Deleting rows with no data (in a range)
- How to delete a row in word - Guide
- Tmobile data check - Guide
- How to increase wifi range - Guide
- How to copy data from one excel sheet to another - Guide
- Excel vba range find - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Jun 2014 à 08:28
17 Jun 2014 à 08:28
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
Posts
21
Registration date
Monday 15 October 2012
Status
Member
Last seen
18 August 2016
2
17 Jun 2014 à 10:35
17 Jun 2014 à 10:35
sorry should have written that I need VBA for this to run when input has been completed.
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Jun 2014 à 18:26
17 Jun 2014 à 18:26
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
