Macro will Only run once

[yunesm]

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: