On Monday, March 26, 2012 10:31:10 AM UTC-5, joe74 wrote: > I have a sheet, where I need to batch 500 products each containing 26 > rows of information (13000 rows). after each batch of 26 there must be a > space, which I have set up. > > I now need to add in column 1 an SKU number for each batch, starting at > SKU-00001 going upto SKU-00500. > > I am wondering is there a way of using the drag and fill to run these > numbers consecutively in batches of 26, to save me having to edit each > one? > > > > > -- > joe74 Sub numbersincolumn() n = 1 For i = 1 To 500 Step 26 Cells(i, 3).Resize(26).Value = "00A" & n n = n + 1 Next i End Sub