Pivot Table thread created: http://www.excelforum.com/excel-work...utomation.html

arnab0711, please mark this particular thread SOLVED.

Quote Originally Posted by E.F.Gubbins
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save