Method 'Range' of object '_Global' error

Here is a quick description of VBA modules.

If the code is in a standard module, like Module1, the Range reference defaults to whatever sheet is active when the code runs.
If the code is in a worksheet module, like Sheet1, the Range reference defaults to the sheet for that module.

If the range Mandatory is in a worksheet that is not the default worksheet based on the description above, then it might help to explicitly qualify it using the worksheet it is in:

Please Login or Register  to view this content.

Change Sheet1 to the sheet actually containing "Mandatory".

I'm not 100% sure that will work but that is typically what causes that error in my own code. I would be happy to troubleshoot it if you attach your file, otherwise we'll tackle it this way.

That worked great! It got rid of the error, but now I'm getting an 'Object Required' error.
Any idea of what I would need to do to resolve this issue?

What module is your code in?
What sheet contains the range "Mandatory"?
What sheet is active when this code runs?
When the "Object Required" error occurs, is it the same code that is highlighted? If not, which code?

It is in a standard module. I decided to move the "Mandatory" range into the ActiveSheet (ws1) which got rid of the '_Global' error.
When I run the code I make sure to be on the ActiveSheet (ws1) that I want to run the code on.
To your final question, yes, it is the same bit of code when I get the 'object required' error.
Thanks for your help again.

I assume your code now refers to Worksheets("ws1").Range("Mandatory")?

I does now and it is working!!
Thank you so much for your help! I really appreciate it!

Phew! Glad it helped. Kind of tough to do this by remote control!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.