Need macro/script to generate serial number labels

Model B Box Labels.xlsx

Take a look at this spreadsheet. The cells and spacing are so that, when printed, the text prints nicely on avery address labels. These labels are then affixed on our products.

I would like to make a macro or vba script that will look at the last serial number on the page (in the lower right hand corner) and then generate the next page of serials numbers starting with the next number in the sequence (when compared to the last number in the lower right hand corner). Ideally, the worksheet would just have a button that the user would click and it would automatically generate a page of numbers.

Is it possible to have the script view the value in the last cell, then overwrite the whole page (including the cell its using to reference) with new serial numbers? Or do I need to copy the last value to a location that wont get overwritten and then reference it from there?

I realize that I could just make page after page of serial numbers, but I would prefer to have a macro that would just make a new page each time it was clicked.


Thanks.

Tiger, You the man! That worked perfectly! Thanks so much.