Assigning a formula to a Cell

[Matt]

I have been trying to assign a formula to a cell and have
been getting an application-defined or object defined
error:

Sub Try()
Range("J7").Formula = "=GetPivotData('LMV%',$B$6,'Sector
Index',$B$7)"
End Sub

I would appreciate any thoughts anyone has on this.

Thanks.

Matt

 

[Tom Ogilvy]

GetPivotData only takes two arguments - at least in xl2000.