Try this
Go to Edit menu, click Find
On the Find Window Click "Options" button and select "workbook" in Within
column

"Alamgir Farooq" wrote:

Dear Sir,


I have a problem, i want to find a value or number in more than 100
worksheets at once so please help me out.

Regards,
Alamgir Farooq