Last column
Posted by TomC on June 14, 2000 12:23 PM
I also need to re-size the last two columns in my pivot table after I change the font. I can locate the last column but I'm having problems selecting it so I can autofit it. This is the code I'm using to locate the column:
LastCol = ActiveCell.SpecialCells(xlLastCell).Column
I tried these methods to re-size it but they both get errors:
Range(LastCol, LastCol).EntireColumn.AutoFit
Columns("LastCol:LastCol").EntireColumn.AutoFit
Any help would be appreciated. Thanks!