Pivot Table to show row values

Hello

I am using a pivot table to get a list of unique values in a range of data (this was the best way I could think of). When I do this manually the rows appear straight away but when I do this as a macro it will not show the values unless I put something into the data section. Is there a way of making it show the rows if I do not use the data section?

This is part of the very messy code I have cobbled together so far. hopefully there is something I can just add to this to make it show the list.

Please Login or Register  to view this content.

Thanks in advance for any help.

Regards

Jim

I have finally figured out the answer to this so just thought I would answer my own question if anone else needed to know.

Please Login or Register  to view this content.

Cheers

Jim