I wrote a macro in excel 2003. When I try to run the Macro in excel 2007 I am getting a run-time error '1004'. The macro works fine in 2003.