Hey Bernie sorry to bug you again but when i put this code into my macro
it always stops at this line:

Columns("A:A").Find(What:="Trash", After:=Range("A7")).Select

and gives this error message:

Runtime error 91 - Object Variable or withblock variable not set.

The only thing I can think of is the portion that says "What" right
after Find. Is this supposed to be defined somewhere?

I really appreciate the help. If I can get this working it would be
fantastic.

thanks
rott


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