Hi all,
I have a function that loads an excel workbook and steps through its sheets creating a sheet of the same name in the workbook that the macro resides in. When I execute it, it just does nothing aside from load the workbook. When I put the breakpoint on the load line and execute, then single step through the code it works fine. Setting a breakpoint on any line after the load does nothing. This has had me scratching my head for hours. I can't find anything on the web. Where am I going wrong?
Any help much appreciated
Marc
Bookmarks