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

       

      airSheet.Range("A2").Select

      '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

       

       

      Regards,

      Sivaramakrishnan K