Good day, all-

See the attached image.  I'd like to have no row where it shows as blank.  But if I filter to exclude blanks, I only show the one row for 'other'.

Any ideas how I can achieve this?

• Moved by Edward ZMicrosoft contingent staff Thursday, September 03, 2015 6:24 AM excel product

Good morning, Edward-
While I can see your point that discussion of Excel Pivot tables may be applicable within the Excel features forum, I was seeking how to achieve my goal via VBA, not through the excel product feature itself.

Perhaps my question was not properly phrased.

After quite a bit of research, I found my answer:

        Dim rng As Range
        Set rng = Range("A7:A" & LastRow)
        
        For Each cell In rng.Cells
            cell.Activate
           If cell = "(blank)" Then
            Dim a As Long
            a = ActiveCell.Row
            Rows(a & ":" & a).EntireRow.Hidden = True
           End If
        Next

• Marked as answer by Casey_M 15 hours 6 minutes ago

Hi,

Thanks for visiting our forum and sharing your experience here. It'll be benefited to our communicator.

Have a good time.

Regards,

George Zhao
TechNet Community Support