Hi All,

I was wondering if someone could help me with a macro I have been trying to create. I am fairly new at macros so please bare with me. I need to a macro to create a pivot table that will pivot Deal No Against Base Amount. However after I create the macro and I try to rerun it, and error always occur. If anyone could help me that would be great.

The code is below and the bold part seems to be causing the error. Again the code should be adaptable. The columns will always be the same, but the rows can vary. Any help on this issue would be appreciated.

Thanks

Please Login or Register  to view this content.