asked on

Count Hidden and Non hiden lines in Excel.

Hi!

I have a big Excel SpreadSheet and many of the lines are hidden.
I want a function that counts the hidden/NonHidden lines.

Thanks
Zmau

SOLUTION

barry houdini

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zmau

ASKER

Hi!

Thanks all.
Sorry it took me a long time to response (vacation).
Barry,
The solution that you had offered works and simple, but it has the disadvantages stated by Dave (dlmille).

Dave,
The solution that you had offered seems to work, but I have some newbies issues.
Maybe it's because I am using Office 2007.

1) What is the "public module of my workbook" ?
I have no idea what does this mean.
2) I have opened the attached file "countHidden-r1.xls" but where is the code ?
According to Excel there are no macroes in the file.
3) I do not understand why do we need the "range" parameter if it is not used.
4) What if I wanted to count beggining in line 2 (After the headings) ?

Zmau

SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zmau

ASKER

Dave,

Everything is OK now :-) .

Regardig question #2 : I had pressed Alt+F8, and got an empty list of macroes.

Thanks
zmau

SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zmau

ASKER

Thanks a lot.
Now, is there a way to put this code/function so it is accesible for all of my worksheets/workbooks ?

Thanks
zmau

SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zmau

ASKER

More than I had expected.

dlmille

FYI - for future, if an Expert delivers "more than expected" you can actually change the points to recognize that before you award.

Enjoy!

Dave

zmau

ASKER

Hi
I wanted to do it, but there is no way to do it in the "Accept solution" page.

Thanks again,

ASKER CERTIFIED SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zmau

ASKER

Thanks

I had learnt another thing from you : "request moderator's attention".
I could not edit the question, so I asked the moderator for 2 things :
1) Add points to you.
2) Enable adding points at the "Accept solution" page.

Thanks
zmau