Prev: Run-time error '1004'
Next: AutoFitMergedCellRowHeight
From: geebee on 11 Jan 2007 11:25
hi,

I have code to chang the page/criteria option for a pivot table:

Sheets("Pivot").Range("B10").Value = Sheets("sheetname").Range("H22").Value

The sheetname.H22 value is actually a date, and it is formatted as a date,
but when I execute the code, it does not work right. I think it has
something to do with the pivot table option formatting because I am getting
an error message:

"No item of this name exists in the PivotTable report. Rename '8/31/2006'
to '39801'"

But I am unsure of what to do.

Can someone help?


Thanks in advance,
geebee



 | 
Pages: 1
Prev: Run-time error '1004'
Next: AutoFitMergedCellRowHeight