control shift down vs dynamic named ranges

[mws5872]

Now the amount of rows will change over time with this macro. I plan to macro control shift down to go to the end of the column. My question is if its 500 this time but 550 next time when the macro runs will it go to 550 or 500? If it doesn't go to 550 how do I get it to do that with dynamic named ranges. Thanks

 

[fabriciofcmiranda]

I don't know if I understood well what you mean... What I do in this case is set the dinamic range until the row below the last row with values. This way, whenever I insert a new row, it goes into the range. So, if you do that, in your case, the range will go from 500 to 550 and you won't have any problem.
Regards,
FM