Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

normal Vba for giving serial numbers in a cell

More
9 months 3 weeks ago #2804 by mikeduke1290
Replied by mikeduke1290 on topic Vba for giving serial numbers in a cell
Automatic serial number in Excel VBA
Generate Serial Numbers by Adding One in the Previous Number
Enter 1 in the cell from where you want to start your serial numbers.
In next down cell, enter formula =G1+1 (G1 is the starting cell here).
Drag this formula to down, up to the serial numbers you want.

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago #2234 by 003434@gmail.com
Vba for giving serial numbers in a cell was created by 003434@gmail.com
Hi Can anyone provide a vba to convert the following:

Cell A1 Value = Lemon, Mango, Apple, Banana

into 

Cell B1 Value = 1. Lemon, 2. Mango, 3. Apple, 4. Banana

Please Log in or Create an account to join the conversation.

Moderators: Excelfans