| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
increment number by code
Hi experts, I think the following question would be very easy one. Now i am using a very simple formula =b1+1 for incrementing the serial number. But the problem comes when somebody try to delete the row the formula affected. So is it possible to write a code for that ? if so where do i place it , in worksheet module ? thanks by nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=388110 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
increment number by code
In Cell B2 =OFFSET(A2,-1,0)+1 This should work because the cell only references itself "nowfal" wrote: Hi experts, I think the following question would be very easy one. Now i am using a very simple formula =b1+1 for incrementing the serial number. But the problem comes when somebody try to delete the row the formula affected. So is it possible to write a code for that ? if so where do i place it , in worksheet module ? thanks by nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=388110 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
increment number by code
Sorry, I had a typo in the first post
In Cell B2 =OFFSET(b2,-1,0)+1 This should work because the cell only references itself "nowfal" wrote: Hi experts, I think the following question would be very easy one. Now i am using a very simple formula =b1+1 for incrementing the serial number. But the problem comes when somebody try to delete the row the formula affected. So is it possible to write a code for that ? if so where do i place it , in worksheet module ? thanks by nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=388110 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
increment number by code
Thanks a lot g bor, it works. But still a question is it possible to have it programatically by a code. regards nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=388110 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increment invoice number | Excel Worksheet Functions | |||
| Auto Increment Number | Excel Discussion (Misc queries) | |||
| How to increment number using vb script | Excel Programming | |||
| increment date code | Excel Programming | |||
| Increment number by 1 | Excel Programming | |||
![nowfal[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
