Creating Multiple Pivot tables

**keithabailey** · 12-10-2009, 11:56 AM

[SOLVED]I have been trying to create a procedure that will create a pivot table for me based on the information I pass it. I have managed this, but when I try to call the procedure more than once I receive 1004 error.

I have attached my work for reference. There are only two macros, one being the procedure itself and one to test the procedure.

Any help would be hugely appreciated.

**Huron** · 12-10-2009, 01:35 PM

Your Name Range for MI_MENU contains a blank column (H) which can't be included in a pivot table. If you change the range to $B$79:$G$997 it will run.