Help with automating macro

J

Joel

I think the problem is very simple. I didn't notice the H's and I's. change
the following in 2 places

from
Do While (Not IsEmpty(.Cells(RowCount, "I")) And _
(.Cells(RowCount, "H") <> Model)) Or _
(.Rows(RowCount).Hidden = True)


to
Do While (Not IsEmpty(.Cells(RowCount, "H")) And _
(.Cells(RowCount, "H") <> Model)) Or _
(.Rows(RowCount).Hidden = True)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top