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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

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
 

Forum statistics

Threads
1,143,637
Messages
5,719,971
Members
422,253
Latest member
frankie2016tata

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top