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.
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).
ActiveWindow.FreezePanes = True
Enter the destination URL
Or link to existing content