Re: Trouble with IF/AND Statement

Mon, 08 Mar 2010 14:26:21 -0700

Posted a 'reply on the VBA forum.

sounds odd, but code ended up working if i altered the code to appear as follows:

If PT.ColumnFields("FM").PivotItems("2009/12").Visible = True Then
            
   ActiveCell.Offset(0, 1).Select
            
            
ElseIf PT.ColumnFields("FM").PivotItems("2009/12").Visible = False And _
       PT.ColumnFields("FM").PivotItems("2009/11").Visible = False And _
       PT.ColumnFields("FM").PivotItems("2009/10").Visible = False And _
       PT.ColumnFields("FM").PivotItems("2009/09").Visible = False Then
            
   ActiveCell.Offset(24, 1).Select
            
End If

Trouble with IF/AND Statement

Mon, 08 Mar 2010 14:17:25 -0700

Posted a 'new message on the VBA forum.

Trying to understand whythis is not working properly...

If PT.ColumnFields("FM").PivotItems("2009/12").Visible = False And _
   PT.ColumnFields("FM").PivotItems("2009/11").Visible = False And _
   PT.ColumnFields("FM").PivotItems("2009/10").Visible = False And _
   PT.ColumnFields("FM").PivotItems("2009/09").Visible = False Then
   ActiveCell.Offset(24, 1).Select
Else
   ActiveCell.Offset(0, 1).Select
End If

The line of code is supposed to verify as to whether the above pivot items are visible under the "FM" pivot field (dosen't matter if pivot field or column field). There is a "2009/12" visible in the pivot table yet it ignores and computes as if it was not visible. Any idea what I may be doing wrong or possible another way of doing this?

mike703's Feed - Programmer's Heaven

Re: Trouble with IF/AND Statement

Trouble with IF/AND Statement