2 issues : Sub call not working + Excel crash

[Megaliz]

The macro I am currently working on presents two issues :

1- It completes fine, but totally ignores the sub procedure called somewhere around the end (Sub Test() ).

2- Again, it runs without giving an error. But when I go back to my Excel sheet to delete data created by the macro (so I can test it again), Excel invariably crashes. After 2 or even 3 attempts at restarting Excel, I manage to delete the data, so I can re-run my macro.

Here is the code :

Please Login or Register  to view this content.

Here is the sub being called :

Please Login or Register  to view this content.

Any ideas ?

[Richard Buttrey]

Hi,

When you say it 'completes fine', do you know for a fact by stepping through the macro that it has completed?
Or do you mean the macro has run without debugging.

If the called macro isn't being run then that suggests that either the IF test has failed or the called macro has in fact run but just not changed any colours.

[Megaliz]

Thank you for your interest, Richard.

Apart from the called subprocedure, I get all the expected outputs from my macro : Excel sheets get updated, saved, closed, no problems.

I went through the code using the F8 key. It stops on the line called "Test" (the subprocedure I'm trying to call), does not move to the subprocedure at all, and just carries on to the next line of code. It just ignores the command.

If I replace the procedure calling with the actual steps of what the procedure is supposed to do (change colours), it works. The reason why I want to call it as a separate procedure is that the actual code that should be added in there is very long, and I want to exclude it from the main program.

Some more ideas ?

[Megaliz]

Richard, by doing some more testing, I found the issue.

To call the procedure, I should call the module first. The line should say :

ModuleName.Test
Test

Then it works.

Now I still need to figure out why Excel crashes every time I run the macro. Have you seen this happening before ?