Use a defined named and just assign the row number to it and save the book?
Regards, Rory Microsoft MVP - Excel
Forum Rules