ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro won't run properly (https://www.excelbanter.com/excel-programming/301152-macro-wont-run-properly.html)

Mystik

Macro won't run properly
 
I have a created a macro that runs when you step into it,
and it works perfect according to my design. However
when i tried to "Run" it, it just stopped in the middle
of the process.

Can someboby please help me identify where the error
could be? Thanks

Nikos Yannacopoulos[_5_]

Macro won't run properly
 
Any chance you are using SendKeys in it? If yes, try to do programatically
whatever you are doing with it. Post for help if required.

HTH,
Nikos


"Mystik" wrote in message
...
I have a created a macro that runs when you step into it,
and it works perfect according to my design. However
when i tried to "Run" it, it just stopped in the middle
of the process.

Can someboby please help me identify where the error
could be? Thanks




Papou

Macro won't run properly
 
Hardly any answer if you don't give details!


"Mystik" a écrit dans le message de
...
I have a created a macro that runs when you step into it,
and it works perfect according to my design. However
when i tried to "Run" it, it just stopped in the middle
of the process.

Can someboby please help me identify where the error
could be? Thanks




Tom Ogilvy

Macro won't run properly
 
If it is in a worksheet code module and it doesn't pertain to a worksheet
event, try moving it to a General Module.

Comment out an error handling (such as On Error Resume Next) so you see if
you are getting errors.



--
Regards,
Tom Ogilvy

"Mystik" wrote in message
...
I have a created a macro that runs when you step into it,
and it works perfect according to my design. However
when i tried to "Run" it, it just stopped in the middle
of the process.

Can someboby please help me identify where the error
could be? Thanks





All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com