Hi,
I have a macro that works in the spreadsheet it was written in but when I try to run it in an identical spreadsheet outside of where the macro is stored then I get the 1004 error.
I understand that this is a reference issue with the sheets but I can get rid of an error in the formula line...