Error - Method Range of object_worksheet failed

**pjbassdc** · 04-02-2013, 01:05 PM

Hi all,

I have been looking around trying to find out what this error means and what I need to do to fix it. I copied some code over from an old project and have placed it into the worksheet of my current project. I was getting a hard fail with error 400. I did some searching and found some code for an error catcher to see what was going on. Now I end up with the above stated error. It seems to be looking for something, but I am not sure what. Can someone please set me straight?

Please Login or Register  to view this content.

Thank you for your help.
Patrick

**Norie** · 04-02-2013, 01:09 PM

Is there a named range called 'CheckRange'?

**pjbassdc** · 04-02-2013, 01:35 PM

Yes, it is a named range on my sheet1 (Form)

**Norie** · 04-02-2013, 01:39 PM

Try adding a worksheet reference for the range.

Please Login or Register  to view this content.

**pjbassdc** · 04-02-2013, 03:07 PM

I added what you suggested and it continues to trip up. I am attaching my workbook if I could bother you to take another look. Perhaps you can glean something from seeing the whole picture. I wanted to error check for missing data in the checkrange list, then move on to the other macros. I had this working on my home computer over the weekend. However, when I sent it back to the machine at the office, it seems to be acting up.

Thak you for your continued help,
Patrick

**Norie** · 04-02-2013, 03:18 PM

There's a #REF! in the middle of the named range, that's what's causing the problem.

Not sure whether to delete it or replace itwith something but if I do either the code stops erroring.

**pjbassdc** · 04-02-2013, 03:55 PM

Wow, glad you spotted that. Yes, somehow I lost my reference to B8 and didn't notice. Must have happened when I was messing around with the check boxes the next cell over.

Thanks again,
Patrick