I have a spreadsheet where I use vba to create a pivot table, then change the positions of the columns in the pt.
The problem I have is that if the spreadsheet does not contain a specific value it errors (Error 1004).
I found code that claimed to check this and that the method was common, I...