Hello,
I have created a macro that splits clients according to their account manager. For ease of use, I have added a freeze pan on cell C6. However, the freeze appears anywhere on the workbook, and I am not sure why.
ActiveWindow.FreezePanes = False
Range("C6").Select
ActiveWindow.FreezePanes = True
ActiveWorkbook.Save
ActiveWindow.Close
Bookmarks