I believe the find method limits itself to visible cells if you look at
Values. Have you tried it?

--
Regards,
Tom Ogilvy

"Soniya" wrote in message
...
Hi All,

How can i limit the search on visible cells only.

I want to use this option to search (Find)data on a
filtered list.

TIA
Soniya