You are welcome

Seems the recorder in 2007 is not working correct
Time that I play more with this stuff (if I have time)



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ozzie via OfficeKB.com" <u18021@uwe wrote in message news:a25d2285da8ed@uwe...
Ron de Bruin wrote:
This is working in 2003

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _
WSNew.UsedRange).CreatePivotTable TableDestination:= _
SecondSh.Range("A1"), TableName:="PivotTable2", DefaultVersion:= _
xlPivotTableVersion10

Hi Ozzie

[quoted text clipped - 47 lines]

it just doesn't like the creating of the pivot


Ron, Thank you very much, it all works very, very well, really appreciated

--
Message posted via http://www.officekb.com