View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dawn Dawn is offline
external usenet poster
 
Posts: 80
Default Copy cells with certain info

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?