Error Message 91

[mnunnley]

Please assist,
From the re-evaluate tab, when the update link is selected, the macro is looking for the changed name for this file.
When the Run is selected, I receive Error message 91 Object Variiable BlockedAssigned Accounts March 1.xlsmAssigned Accounts March 1.xlsm

[gmr4evr1]

I have taken a look at this for you and may have find where the issue lies, I'm just not sure why it is doing it. It seems that in both module 1 and 3, the following line errors out...

Please Login or Register  to view this content.

The bolded area is highlighted in the VBA code when the error happens.
Haven't been able to figure out why it errors there, but after it loops through the 2nd or 3rd time is when the error occurs.

[xladept]

Hi Malisa,

This is the first time that that code has failed - try this:

Please Login or Register  to view this content.

Malisa.xlsm

[mnunnley]

Thank you for your assistance.

The only change I made from the initial document was the addition of the Roll up tab and I changed the name from mnunnley to Assigned Account March 1.
I updated the code however I still receive the error message:

Cannot run the macro" Assigned Accounts March 1. xlsm'!mnunnley'. The macro may not be available in this workbook or all macros may be disabled.

[gmr4evr1]

Assign one of the other codes to the button by right clicking on the button, then click Assign Macro and select one of the 2 macros listed. I have to do it when I open either of your 2 files, then it works.

[mnunnley]

Thank you for your help. This resolved the issue. Again you are truly a GENIUS. No one else was able to assist me with this post.

[gmr4evr1]

Thank you....although, it was a combined effort as 2 of us helped out.
Glad it's all working for you now.