I want to set different freeze panes for different sheets in a excel. I tried using the below code but this is being assigned to all sheets. But I want to freeze first 6 rows in my first sheet and only top row in second sheet. I tried so many ways but no result. Any suggestions? Thanks in advance
With xlApp.ActiveWindow
.SplitColumn = 0
.SplitRow = 6
End With
Aucun commentaire:
Enregistrer un commentaire