Application.run Not working (Stepping Over with no Error Message)

[stevoDE]

Hi

I have the below line of code within a module of a workbook and my aim is to run the DiscrepancyFormatting macro within the Daily Template workbook which is also open however nothing happens when I run the macro or step through this line of code. I don't receive an error message either.

Please Login or Register  to view this content.

Has anyone come across this before?

Thanks in advance

[xlnitwit]

Hi,

Do you perchance have an On Error Resume Next statement in your code?

[stevoDE]

As a matter of fact, there is yes. The original code was actually written by someone else which I am now tweaking.

Have just taken that off 'On Error Resume Next' off and I am now getting a Run-time error 1004 message: Cannot run the macro "Daily Template.xlsm'!DiscrepancyFormatting'. The macro may not be available in this workbook or all macros may be disabled.

Any advice on that appreciated.

[xlnitwit]

Which module is the DiscrepancyFormatting code in in the Daily Template workbook?

[stevoDE]

Sorry for the late reply on this xlnitwit.

The issue was due to the fact that I had renamed the macro within the VBEditor so in order for it to run, I had to amend the code to:

Please Login or Register  to view this content.

Quite annoying! Not sure if there's any easy way around having to reference the name twice.

[xlnitwit]

Yes- simply don't use the same name for the module and the routine.

[stevoDE]

And then just refer to the name of the routine and it should run?

[xlnitwit]

Yes it would just be

Please Login or Register  to view this content.

[stevoDE]

Got it, thanks very much!