Discussion Locked

VBA Programming Question - Excel

0 helpful

2 replies

by bberzin Jan 19, 2004 last reply Jan 19, 2004

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need a VBA programming statement that will delete an entire row on an Excel spreadsheet if a value in one of the cells in that row equals 0.

2 replies

Roughly it would be:
For each cell...
If cell.value=0
TrashRow=True
Next cell
If TrashRow Then
cell.EntireRow.Delete
TrashRow=False

or code to that effect

Look at:
Ozgrid.com
Deleting Rows in Excel
http://tinyurl.com/ysbsk

This discussion is closed to new replies.