Set rng = Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
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
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?