I actually tried this and the problem I had was that when I recorded the
Macro, it didn't look for just any visible rows. it listed the specific rows
I clicked on. This will not work since the rows will change each time. Is
there a command that specifically looks for only the visible rows left after
the autofilter? I couldn't find anything like that.

Thanks

"Dave Peterson" wrote:

Maybe you could apply Data|Filter|autofilter to that column.

Filter by that word (or contains that word) and then copy the visible rows.

If you really need a macro, you could record one when you do it.

(If you have trouble with your recorded macro, post back with your questions.)

Dawn wrote:

I would like to write code to look through a column for a specific word and
if that word is found, select the entire row. Then I would like to loop this
so it goes through a whole group of information. It seems I should be able
to use an If...Then statement to begin with, but then I'm not sure how to
write the code for copying the whole row. Also, is there a better way to do
this besides looping?

--

Dave Peterson