I have modified code from a workbook developed by Contextures. I am getting a run time error on the following code:
The line in red is where the error is occurring. Error number 1004: Method range of object _worksheet failed. I have attached a modified version of my workbook. I think that I have referenced something incorrectly, but I am not sure where to fix it.
Please Login or Register to view this content.
Any help is greatly appreciated.
Hi williakm1013,
Welcome to the forum!!
The name range has actually been called CritieraRng when it was created whereas the code is referring to a named ranged range called CriteriaRng (note the additional 'i'). The two have to be exactly the same, so either renamed the named range or change the code.
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks