What makes a "macro" created take so much time to run?

**LIVIA** · 05-07-2009, 12:23 PM

I created a macro (ro run solver's)with VBA and the macros works fine.
The issue is that the macro is taking more than 2 minutes to run, while when I created was taking less than 10 seconds the same amount of solver's!

Does anybody know what can cause the "delay" on the macro?
Could it be damaged becaused I saved the macro several times in different files versions?

I already tried to copy the macro and paste again on a new file, but it is still very slow... Anybody knows what can be causing this issue?

THanks!!

**c.vaibhav** · 05-07-2009, 12:29 PM

Hi livia,

Please post the macro that are using.

Macro could not be damaged by the number of times it has been used. It can be used innumerable times.

Regards,
Vaibhav

**LIVIA** · 05-07-2009, 12:35 PM

I just dont know how to use codes to post the macro... sorry

**shg** · 05-07-2009, 01:11 PM

Please read the forum rules, and then edit your post to add code tags.

**c.vaibhav** · 05-07-2009, 02:16 PM

I accidently posted one more message..
How to delete my own post??

Sorry for not having read the forum rules..

Regards,
Vaibhav

**shg** · 05-07-2009, 02:19 PM

c.vaibhav,

Your post does not comply with Rule 7 of our Forum RULES. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc