increment number by code

[nowfal]

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

[gbor]

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
>
>

[gbor]

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
>
>

[nowfal]

Thanks a lot g bor, it works. But still a question is it possible to have it programatically by a code.
regards
nowfal