one more question:

Q1:

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase
SourceData:="Sheet1!R3C3:R261C21" _
).CreatePivotTable TableDestination:="", tablename:="PivotTable3"
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(1, 1)

How can I change to R1C1 style from activesheet.UsedRange?
SourceData:="Sheet1!R3C3:R261C21"

Thanks

--
Message posted from http://www.ExcelForum.com