1
how to create 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
Answer Question
| January 23, 2012 6:46 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications
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
Microsoft Access AutoNumber
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to [...]
Answer Question
| February 25, 2009 12:01 PM
AutoNumber, Database programming, Microsoft Access, Microsoft Access auto increment, VBA
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to [...]
1





