Hey all,
I want my excelsheet to scroll from row number 10 and freeze the cells in range of A1:AA9,
but with the following code, the scrolling starts working from row 14, while I have never specified in my code to scroll from there:
Dim wbNew As Workbook Set wbNew = Workbooks.Add wbNew.Sheets("Blad1").Columns("A:AA").EntireColumn.AutoFit wbNew.Sheets("Blad1").Range("A1:AA9").Select ActiveWindow.FreezePanes = True
Bookmarks