I am facing a peculiar problem while running a macro in Excel 2007. This macro is being run in an excel file named "Test.xlsm". My macro code is as under -
Now the problem is that the code runs without any problem in the debug mode. But when I execute the code using the shortcut key assigned to the macro, the program stops after opening the file in line no. 1.Please Login or Register to view this content.
Can someone suggest a solution to this problem.
Bookmarks