Recent content by Naz

I think I know what the issue was. When a pivot is created it automatically creates a new sheet with a number but if that sheet number is already used it won't work. I recorded the pivot macro again and started it on a named sheet. So the Macro can only be run on that named sheet which must...

Yes

Yes, I started again, still same thing. Maybe it's to do with how the Macro is saved? I saved it on the Workbook .

When I initially recorded the Macro I created a pivot table from data on Sheet1 and the pivot worked fine. I saved and closed.

Thanks but that then creats a Syntx error.

Hi Everyone, I have recorded a very simple Macro to pivot some data and when I run the macro I keep getting this error. When I click on Debug the yellow highlighted data below seems to stop it from running.. Any ideas what this means or how it can be rectified please?