#1
|
|||
|
|||
Auto Serial number Using VBA
Dear Sir
This code is working perfectly but how can I use this formula for Auto Serial number for specified range for exp A3 to A33 please help For i = 2 To Cells(Rows.Count,"B").End(xlUp).Row If Cells(i,"B").Value <> "" Then Cells(i,"A").Value = i - 1 End If Next i Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to preset serial number in 00000# format | DarkNinja | Word VBA | 4 | 03-28-2021 12:13 AM |
Looking for help with creating sequential serial number on one page | 4ener | Word | 9 | 02-24-2019 07:50 AM |
Add a serial number to an invoice | pringle747 | Excel Programming | 6 | 02-19-2015 11:19 AM |
Increase serial number for every print | atomtm | Word | 1 | 06-15-2012 05:39 AM |
Serial Number Issue | rehan5001 | Excel | 1 | 06-08-2011 02:46 AM |