7 Replies Latest reply: Jun 30, 2014 10:14 AM by Sathish Kumar RSS

    Excel macro export to freeze panes

      I am trying to freeze panes using excel code but it isn't working.

      I tried the following codes:



      XLDoc.Sheets(LCR).Range("F5").FreezePanes = True




      With XLDoc.Sheets(LCR).Range("F5").Select

              XLDoc.Sheets(LCR).FreezePanes = True

      end with


      Can anyone tell me what I am doing wrong?


      Thank you!!!!