ExcelBanter - Limit search on visible cells only

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Limit search on visible cells only (https://www.excelbanter.com/excel-programming/278847-limit-search-visible-cells-only.html)

Soniya

Limit search on visible cells only

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

Tom Ogilvy

Limit search on visible cells only

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

All times are GMT +1. The time now is 06:05 PM.