Macro will Only run once

**yunesm** · 11-22-2011, 12:24 AM

Hello,
This is a repost of closed thread with what is hopefully a better description of what I'm working on.

I have a spreadsheet that I'm using to build a table with named ranges.

The simple explaination of the issue is that the code runs once and will not run again (macro = AddValues).

If I step through the same code it works fine but when I actually run it it won't run the second time. If I close and re-open it still will not run.

Also, if I run one of two other macros (macros = OverRide or DeleteProvider) and then try to run the AddValues program it won't work then either.

By themselves the code all seems to do what it's supposed to do but I'm not sure why it only runs once or why the same code works when I step through it or run it with breakpoints inserted.

The pimary code that I'm having an issue with is:

**yunesm** · 11-22-2011, 09:33 AM

Hello,
I am adding to this thread with what is hopefully a better description of what I'm working on...

I have a spreadsheet that I'm using to build a table with named ranges.

The simple explaination of the issue is that the code runs once and will not run again (macro = AddValues).

If I step through the same code it works fine but when I actually run it it won't run the second time. If I close and re-open it still will not run.

Also, if I run one of two other macros (macros = OverRide or DeleteProvider) and then try to run the AddValues program it won't work then either.

By themselves the code all seems to do what it's supposed to do but I'm not sure why it only runs once or why the same code works when I step through it or run it with breakpoints inserted.

The pimary code that I'm having an issue with is: (same as above)

I'm sure that I'm doing something stupid but I can't or I'm too tired to find it! Wondering if anyone could take a look at the code. To keep the length of the post to a minimum I only added teh AddValues code. The other programs are available in the attached sample file.

Any help would be greatly appreciated!

Thanks!

**jaslake** · 11-22-2011, 12:17 PM

Hi yunesm

Move this line of code...see if that helps

Please Login or Register  to view this content.

I don't know why but it appears to work.

**yunesm** · 11-22-2011, 02:01 PM

Hey John!
Thanks for taking a look at this I really appreciate it. You're right this seems to take care of it. I don't know why that changes this but at this point I'm not going to worry about it.

Thanks again for your help.
Thanks!