lundi 11 mai 2015

How to set different freeze panes for different sheets in a excel using vb.net

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