named range programmatically editable?

I have defined a few named ranges in one of my worksheets, upon which some of my validated options depend. This is fine as long as everything remains as it is. Once in a while I may have to change this by hand to adjust the named ranges.

I am wondering, if this is doable by vba macros? Could I code to do this to effect any change in my named ranges?

Say, for example, I like to expand one named range called "optionA" to be two rows more to contain two more options. I do not want to do this by hand, but purely by codes.

You may use:

Please Login or Register  to view this content.

However you may be able to define the range with a dynamic formula so that it expands as you add data with no programming required.