VBA to change range that users are allowed to edit

[chaddug]

Is it possible to use VBA to change the range that users are allowed to edit?

I have a sheet with a list that is sortable by users when the sheet is protected, however they cannot change the values on the list. I did this by clicking on the button that says "Allow Users To Edit Ranges" then entering the range of the list that I want to them to be able to sort.

I want a code that will change that range based on some other criteria. I tried to record a macro of myself changing the range, but it just gave me an empty sub. Is there a way to do this? The code would hypothetically go like this:

Please Login or Register  to view this content.

Any help on this, or suggestions on how to do this another way would be appreciated. I tried defining the range with a formula, but that only works once, as it converts the formula to a static range.

Thanks,
Chad

[chaddug]

Nevermind,
I figured it out. Just have to delete the range, then add a new one

Please Login or Register  to view this content.

[Domenic]

Or, simply...

Please Login or Register  to view this content.

Actually, let's make that...

Please Login or Register  to view this content.

Hope this helps!

[chaddug]

That does help, thanks!!

[Domenic]

You're very welcome!