excel vba freeze pane without select

by

Record yourself using the View ► Freeze Panes ► Freeze Top Row command and this is what you get for .FreezePanes.

With ActiveWindow
    If .FreezePanes Then .FreezePanes = False
    .SplitColumn = 0
    .SplitRow = 1
    .FreezePanes = True
End With

So modifying the .SplitColumn and/or .SplitRow properties should do it for you regardless on what the ActiveCell property is.

More Related Contents:

  1. Excel VBA – How to add dynamic array formula
  2. How can I URL encode a string in Excel VBA?
  3. Compare double in VBA precision problem
  4. Row count on the Filtered data
  5. Excel VBA Macro: User Defined Type Not Defined
  6. Automate IE via Excel to fill in a dropdown and continue
  7. Run-Time error 1004 Excel 2013
  8. VBA – Write all possible combinations of 4 columns of data [duplicate]
  9. Excel VBA to Export Selected Sheets to PDF
  10. Remove duplicates from array using VBA
  11. Controlling Internet Explorer local intranet using Excel VBA
  12. How to automatically insert a blank row after a group of data
  13. Count unique values in Excel
  14. Get File Path (ends with folder)
  15. Get length of array?
  16. Email a single attachment from folder of files each to a different person
  17. Bad data selection using VBScript , on date field values
  18. Sending object array to variant works before August 2019 Windows update, but fails after update
  19. Find last row in range
  20. Differences between Excel’s Form Controls & ActiveX Controls
  21. Excel VBA User Defined Function that counts cells with conditional formatting
  22. Excel VBA to match and line up rows
  23. Change font color for a part of text in cell
  24. Create a new object using the text name of the class
  25. Excel cell from which a Function is called [duplicate]
  26. How to open a workbook specifying its path
  27. GET pictures from a url and then rename the picture
  28. Create folder path if does not exist (saving from VBA)
  29. Access files with long paths (over 260)
  30. Concatenate multiple ranges using vba

Leave a Comment