control shift down vs dynamic named ranges

mws5872

New Member
Joined
Oct 10, 2006
Messages
11
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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

fabriciofcmiranda

Board Regular
Joined
Jun 27, 2006
Messages
62
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,096
Messages
5,545,926
Members
410,713
Latest member
TaremyLunsil
Top