5 Replies Latest reply: Jul 1, 2014 10:11 AM by whiteline _ RSS

    Freeze panes while generating a Excel file using macros

    Sathish Kumar

      Hi all,


      I want to freeze all panes in my four worksheets.i am using the below code to freeze panes in sheet1 code



      'XLApp.ActiveWindow.FreezePanes = True


      if i use this same code in sheet2 also means it is throwing subscript out of range exception

      kindly provide me a solution




      Sivaramakrishnan K