Count of Visble Range Rows

        Set rng = Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
        MsgBox rng.Addres

Open in new window


I have the above code. The message box gives me ($A$1,$A$7) However, when I do a count of the rows in range, using code below

rng.rows.count

the result is 1 instead of 2. How can I go on to make sure that the both cells are counted when I count the # of rows in range?

Thanks!
LVL 13
Shanan212Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try
rng.Cells.Count

Open in new window

Regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.