When I record the creation of a pivot table, and choose for my data source columns A:D, the code recorded for the column selection is similar to this, showing C for columns 1-4:I then put that same code back into my macro, looking like this:![]()
Please Login or Register to view this content.
However, when I run my macro, instead of the source being Columns 1-4, the source is column c, rows 1-4. How do I tell my macro I want columns 1-4?![]()
Please Login or Register to view this content.
Bookmarks