Pivot Table Creation

Hi, I'm trying to create a pivot table but without success. It's a very simple pivot which should group on a field called NAME and then sum the values. I first tried to record a macro and then use that code but that didnt work so I've "assembled" some code that almost works but not quite. Here's the code

Please Login or Register  to view this content.

If I take out the last line of code the pivot table creates but without a data field. When I put the last line in I get a syntax error which, for the life of me, I can't figure out....very frustrating... I'd appreciate any help...even if it means going back to scratch

Many thanks