Basic Marco Help

[Lonney]

Hello All,

I have an odd issue. I have a basic macro which will not run.
When running the below macro, I receive this error: Application-defined or object-defined error
The sheet name is: ManagerReport (Manager Report)

I recorded the macro, and it provided the below code, with the same issue. I don't know where to turn. Help Please!!
<code>

Please Login or Register  to view this content.

[TMS]

Code looks ok. Suggest you post a sample workbook.

Regards, TMS

[Lonney]

Thanks TMS - Hopefully you can identify the issue. You will see that I have buttons across the top of the page. Then the corresponding macros, which I cannot get to work! Thanks for your help.

Excel Example Macro.xlsb

[mgs73]

Typo - your code refers to 'ManagerReport' (no spaces) but the sheet name is 'Manager Report'.

[Lonney]

I tried that, with the same results. I have the same issue. I have tried with and without spaces. I also recorded a macro to eliminate human error, and same error.

[mgs73]

I see now... Even typing ? ActiveSheet.Name in the immediate window when Manager Report is active causes the same error. Call Stats also seems to have the same problem.

I had the same problem recently, and if there is a solution I don't know what it is. Hopefully someone here can enlighten both of us!

In the end, I started from scratch, copying and pasting from old to new - not fun...

[Lonney]

At least I am not the only one! Thanks and hopefully someone will chime in.

[alansidman]

I just ran your code in the workbook you attached and it worked with no error or issues. Cannot replicate your problem.

[TMS]

This is your code:

Please Login or Register  to view this content.

The code name for the worksheet is "ManagerReport". The sheet name for the worksheet is "Manager Report"

So, using the sheet/tab name, you could have:

Please Login or Register  to view this content.

or, using the code name, just:

Please Login or Register  to view this content.

Note that, for the latter option, you would have to change the subroutine name from "Sub ManagerReport()" as Excel/VBA would get confused. It is not good practice to have subroutines with the same name as Excel/VBA objects, properties, variables or reserved words.


Regards, TMS