Re: List of worksheets in the folder
Don't have the xlsm Workbook that contains the above code in the same folder as the one your searching on..
If I take the workbook out of the folder which is searched the code works perfectly. Thanks a lot for it. Is it possible to modify the macro that the workbook can be in the searched folder? If not, do not worry, I can live with it
...do you realise that the INDIRECT formula does NOT work on closed workbooks? It would be a shame to do all this work only to discover you can't do what you originally wanted to do. If you do know this then all good.
Yes I am aware of this. I will need to open some workbooks to make it working