I have an excel spreadsheet which I want to add two things to a macro I
have.

This first thing is I want to search a single column and delete any
rows that have 0 (zero) in it.

The second thing I want to do is to fill a column with a word (the
column heading title) down to the last row. If the fill is done in
more or less completed rows then I get an error when I import the data
into another application.

So I suppose I need code to look for data in say, the first column and
stop when it finds a blank.


---
Message posted from http://www.ExcelForum.com/