Does anyone know why my code won't create a Pivot Table?
Thanks
Sub create_pivot_table()
mc = Range("A1000000").End(xlUp).Row
mcc = Range("XFC1").End(xlToLeft).Column
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _...