Hi all - I've been encountering an issue with workbooks that contain an ampersand. If i do something like try to copy data from one open workbook to another in VBA and the workbook is named something like "M&M Box Company.xlsm", I will get a "Subscript out of range" error, because the name is not getting read correctly and it thinks the workbook im referencing does not exist. If I change the workbook name to "MM Box Company.xlsm", code works fine. Any idea what I should do to correct this problem? (other than having to remove the ampersand from the file name each time, obviously not an ideal solution). Thanks!