Complex dynamic named ranges

[Angelfish13]

Hi,

I had to edit this post because I figured out 95% of the solution to my problem. I wanted to create a named range that I could insert a new row into the range within a macro. I figured out how to do that (almost). The only problem I have now is that when I try to insert a new row to my range, it keeps inserting one line above the end of the data, instead of one row below like I would like. I have posted my code below, I cannot figure out what is wrong. Thanks for the help!

Please Login or Register  to view this content.

[boon-yao.tek]

is it okay to add row first, then expand your name range?

Please Login or Register  to view this content.

[Angelfish13]

It works!!!!!! Thank you so much!!!