![]() ![]() ![]() (TableDestination:=PSheet.Range("B3"), TableName:="Total Backlog") TableName:="Total Backlog", DefaultVersion:=xlPivotTableVersion14) _ĬreatePivotTable(TableDestination:=PSheet.Range("B3"), _ (SourceType:=xlDatabase, SourceData:=PRange, Version:=xlPivotTableVersion14). Set PRange = DSheet.Cells(1, 1).Resize(LastRow, LastCol) LastCol = DSheet.Cells(1, Columns.Count).End(xlToLeft).Column LastRow = DSheet.Cells(Rows.Count, 1).End(xlUp).Row Set DSheet = Worksheets("US Master Macro") I have saved the workbook as Excel Enabled-Macro Workbook as well as Excel Enabled-Macro Template. Also, the weirdest thing is that I developed a code similar to the one below and it works. I have changed a lot of the settings regarding the compatibility of the code between 365 and Professional Pro and have learned that the 365 automatically updates while the Professional Pro doesn't. I am having a difficulty trying to get my code to work on the Excel Professional Pro for PC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |