View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
dhatul
 
Posts: n/a
Default Problems in running a macro in another workbook

Bob,

To respond to your query only the worksheet '2148' opens and nothing
happens after that. That is to say that no line are executed
thereafter. The selects are not redundant as these were written
precisely to check whether the macro is being executed or not.
Incidentally, the above small macro was written for debug purpose only,
to home down to the problem area. The real macro that I want to be
executed is in the link provided in my original post.

More importantly the entire macro works/executes perfectly in the debug
mode when executed line-by-line (F8).