userform checked and unchecked instances

[arleutwyler]

Hi all, hopefully one you masterminds could help... I am using a "Sheet button" that when pressed a user form with 6 checkbox's and a button is called, when a box is checked and button pushed a named range is copied from a "range sheet" then pasted in the activesheet with an appended named range. When I click the "sheet button" a second time it remembers the previously selected checked boxes and when I uncheck one of the boxes that were previously checked it searches the active sheet for the appended named range and deletes it.

Right now this only works if all the boxes are checked then all the boxes are unchecked. I get the error below if I try to selecting anything but everything. I have spent to many hours and I'm pretty sure I have hit a wall.

This is the error I keep running into...
Run-Time error '1004':
Method 'Range' of object'_Global' failed

Any help would be appreciated

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.