View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
srinivasan srinivasan is offline
external usenet poster
 
Posts: 30
Default serial numbers with hidden rows

I want know whether it is possible to create continuous serial numbers in
rows of column A without taking in to account of the rows that are hidden.
Again when I un hide the rows the numbers should automatically change in
sequence. I got a macro for doing this from community. But will it possible
to do that through a formula?
Will some one throw light on this?