Home > IT Answers > Development > how to create autonumber
Army
100 pts.
0
Q:
how to create autonumber
Excel VBA, VBA, Visual Basic for Applications, Excel 2007, AutoNumber
while press enter on cell (b1)
the cell (a1)= 1
while press enter on cell (b2)
the cell (a2)= 2
and so on
i tried functions :
=row()
and =OFFSET(A2,-1,0)+1
i don't think its an autonumber because i used manualy
so, hlp pls
ASKED: Jul 10 2009  6:46 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Army
100 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Jul 10 2009  6:46 AM GMT by Army   100 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0