http://www.microsoft.com/communities...r=US&sloc=&p=1


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"nish" wrote:

Hi Guys

How can we look for a number in different workbooks? For example, I
have 10 workbooks opened on my desktop and I want to look for a number
or a name while I do not know in which workboo this numer or name is,
how can I look for it? I know we cannot use Ctrl + F, as it only works
in the active spreadsheet.