I copy and pasted your code, it says the macros are disabled...how do I enable the macros? I thought by saving the file as xlsm that macros would be enabled...why did it work initially, then stop working? strange..