[Solved] EXCEL VBA Code to generate serial numbers from a range [closed]
Try this out and let me know if it works for you.. This will provide you with the results shown in your picture. Sub SerialCode() Dim ws As Worksheet Dim startOf As Long, endOf As Long, data ‘startOf and endOf are Long for >5 digits. Dim lastRow As Long, currentRow As Long Dim dataRange As … Read more