Since this is in .programming...

In XL, turn on the macro recorder (Tools | Macro Record new
macro...), do by hand whatever it is you want, and turn off the
recorder. In most cases, XL will give you the necessary code that, if
necessary, can be further refined.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I need to get worksheet to find everything with words i want to find and copy
hole line to another place...how can i possibly do it?