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:

       

      1.

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

       

      2.

       

      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!!!!