• Ask a Question
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Top Contributor

      VBA Freeze Panes at Specific Row and Column

      I would like to freeze first row and fifth column in a worksheet, how can i do it using VB. It will be great if you could give a code.

      Asked by pranab79in on February 23, 2017 in VBA: Macros.
      1 Answers
      Expert

      Hi,

      Here is the VBA code to set the Freeze Panes at Range F2. i.e; at Row 2 and Column 6 (This will freeze the Column 1 and Column 5).

      Sub sb_VBAF1_FreezePanes()
      Range("F2").Select
      ActiveWindow.FreezePanes = True
      End Sub
      

      Thanks!

      Answered by Valli on February 23, 2017..