Pivot tables - blank rows

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?

September 2nd, 2015 4:59pm

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.

Free Windows Admin Tool Kit Click here and download it now
September 3rd, 2015 8:35am

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
September 3rd, 2015 12:26pm

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

Free Windows Admin Tool Kit Click here and download it now
September 3rd, 2015 9:28pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics