Deleting rows with no data (in a range)

Closed
Debs269
Posts
23
Registration date
Monday October 15, 2012
Status
Member
Last seen
August 18, 2016
- Jun 17, 2014 at 04:14 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 17, 2014 at 06:26 PM
Hello,

I have a sheet that I have been working on..all working fine, however I have one last bit that I cant seem to get right.

Worksheet - "Front Page"
Range is B28:H82

A few of the rows have data in... but I want to be able to remove the rows that have no data in...

Can anyone help?

Thanks in advance
Debs



3 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0
Debs269
Posts
23
Registration date
Monday October 15, 2012
Status
Member
Last seen
August 18, 2016
2
Jun 17, 2014 at 10:35 AM
sorry should have written that I need VBA for this to run when input has been completed.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0