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