Prev: Unhide rows in an Excel Macro
Next: find range question
From: Abdul Qadir Abdul on 23 Apr 2010 05:57
Dear I tried this one but it is not working properly. May be I am getting
wrong. Can you explain how can I use this code and where?

Regards

Abdul Qadir



"galimi" wrote:

> You may just need to turn on auto calculation.
> --
> http://HelpExcel.com
> ed(a)helpExcel.com
>
>
>
> "srinivasan" wrote:
>
> > Dear Mr Galimi,
> >
> > Thanks a lot for your reply.The code provided by you fulfills my object. But
> > the serial numbers are not automatically adjust itself and renumbers when
> > ever a row is hidden unless I recalculate the sheet using F9. Can it be
> > still improved ?
> >
> > "galimi" wrote:
> >
> > > 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
> > > ed(a)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
 | 
Pages: 1
Prev: Unhide rows in an Excel Macro
Next: find range question