Results 1 to 6 of 6

Thread: Resolved - How to count the number of rows except hidden rows?

Threaded View

  1. Sep 4th, 2005, 11:00 AM #1
    cssriraman
    cssriraman is offline

    Thread Starter
    Frenzied Member cssriraman's Avatar
    Join Date
    Jun 2005
    Posts
    1,465

    Resolved Resolved - How to count the number of rows except hidden rows?

    I have some sort of data on my excel sheet in 30 rows. Let say A1 to A30.

    Here some rows were hidden. Let say A5 to A8 totally 4 rows were hidden. I just want to count the number of rows except hidden rows.

    I just tried the following code.

    VB Code:
    1. MsgBox ActiveSheet.UsedRange.Rows.Count

    This code counts the all row which are used in active sheet. The above code gives the answer 30. but my answer should be 26 not 30.

    Thanks in advance!

    CS.
    Last edited by cssriraman; Sep 4th, 2005 at 09:12 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width