Prev: How do i select the coordinates of the first column & last row in a pasted range
Next: Number Format. Switch Comma to Dot
From: Scott Scott on 15 Dec 2009 17:28 Hi, I'm trying to add pivot filter with multiple values checked using visual c# 2008, we tried using the xldatebetween syntax property of the pivot function, but keep getting an error on the object data property. Can someone please guide me to the right syntax below is the string from the code tablePage1.PivotFilters.Add(Excel.XlPivotFilterType.xlDateBetween,tablePivot.PivotFields("Posted Date"),"12/7/2009", missing, missing, missing, missing, missing); |