Thread: serial numbers with hidden rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default serial numbers with hidden rows
try
=row()

--
Don Guillett
SalesAid Software

"srinivasan" wrote in message
...
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?



Reply With QuoteReply With Quote