Error when calling macro

[jamer02]

Hello,

Got an issue with a macro, in that when I use the "Call" function to run a macro I get a compile error saying "Invalid use of property", but for some reason it only does this with one particular macro and works fine when trying to call any other macro.

Any ideas why this could be?

Any help would be much appreciated.

Jamer

[jamer02]

Just noticed this seems to be because the macro, for some reason, changed its name to this format...WorbookName.xlsm!Module4.MacroName...any ideas why this has happened?

[stanleydgromjr]

jamer02,

Are both macros in the same workbook?


Can you post both macro codes?


If posting VBA code, please use Code Tags - like this:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

[jamer02]

Both macros are in the same workbook yes. I can call the macro if I tell the code what module the macro is in, would prefer not to do this if there is a way of changing this?

[stanleydgromjr]

jamer02,

Can you attach your workbook?

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.


If I can not see your workbook, or the macro code, then:

In the Quick Reply box, just put the word BUMP. Then, click on the Post Quick Reply button, and someone else will assist you.