View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shruti shruti is offline
external usenet poster
 
Posts: 1
Default serial updation in locked rows

I have created a long nested if formula and given its reference in others
cell.also i have locked the particular cell and protect the sheet.now i want
that on inserting new row it will take the serial row where as it is taking
1+cell number in original formula.