Hello,

I have the following code:

ActiveSheet.PivotTables("PvtVarianceRpt2").PivotFi elds
("Line").CurrentPage = cboLine.Name

Where cboLine is a combo drop down list.

It keeps asking for "Object required"

How might I go around fixing this?

Thanks in advance for the replies,
Grant.