| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 4981 | 2000-07-15 03:27:00 | Excel - If row is blank, delete row, this for 1st 200 rows. | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 5475 | 2000-07-15 03:27:00 | If row is blank, delete row, this for 1st 200 rows. I have a sheet emailed to me, in which I would like to delete all the empty rows, contained in the 1st 200 rows in that sheet. Is there an easy way I can do this. Finally, as per above, I would like to delete any row (in the 1st 200 rows) that contains nothing in the 1st column of that row. Thanks in anticipation....John Prefer this in Xl4 macro language if possible.. John jhw@xtra.co.nz |
Guest (0) | ||
| 1 | |||||