Hi, as the title says how would one go about doing this. For instance if in a new spreadsheet Cell A2 had the number 6 in it, how do I use the record macro (with relative reference) to generate integers 1 to 6 say in cells B4 to B10. I don't want to know how to write the VBA code for this since that is straightforward.