View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default highlighting rows when a value has been found

lots of options, depending on how you want to highlight the row but the
simplest might be.....

Rows(Activecell.Row).Select

--
Cheers
Nigel



"mike" wrote in message
...
hi,

i am using the find method, and at present it highlights only the value

that
i have asked it to found.
i would like it to highlight the entire row or column where the value

lies.
is this possible?
look forward to your replies.
thanks

mike