I have posted an example to http://www.HelpExcel.com/examples
The title is hidden.xls
I use a simple function to determine whether the row is hidden or not:

Public Function hiddenRow()

Application.Volatile True

hiddenRow = Application.ThisCell.Rows.Hidden

End Function

--
http://HelpExcel.com




"srinivasan" wrote:

Dear Community members,
I am having a worksheet withlot of data with continuous serial number in col
A. I would like to know if it is possible to provide continuous serial
numbers without taking in to account of the rows that are hidden. i.e if row
5 is hidden the serial number should continue with row4 to row 6 without
taking int o account of the hidden row 5
thank you