Hi,

I have around 100 excel files in a folder, each excel files are on the same format and has only one sheet named as shee1.

I have a master file where i have all these file names like
test.xls, crake.xls etc from A1 to A100.

Now I want to check if all these files have any values from D37:D45
If anywhere in the range D37:D45 has any value that particular file name should be identified, either colouring or making bold anything..


Why i need is because, i need to open akk 100 files and check if that file has any values in range D37:D45, if a macro identifies the file names then i can open only those files.

Appreciate your helps
Thanks.
Arvind