You do realize that if you loop through all open workbooks you'll loop through all hidden instances of workbooks as well, i.e. Personal.xls.
HTH
You do realize that if you loop through all open workbooks you'll loop through all hidden instances of workbooks as well, i.e. Personal.xls.
HTH
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Posting Permissions
Reply With Quote