How to freeze frame in excel mobile3/16/2024 ![]() Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. Scroll down to the rest of the worksheet. ![]() XlWb.worksheets("Sheet1").range("A6"). On the View tab, in the Window group, click Freeze Panes. I would recommend always explicitly specifying which sheet you want active for this, since it requires ActiveWindow in order to function, that way you won't ever accidentally be on the wrong window when you're setting your split rows. Try this out, replacing the sheet names, rows & columns with the appropriate values: Worksheets("Sheet1").activateīased on the code you posted in comments, this should work: Dim xlApp As Application
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |