Set c = (Target.Cells(1).Row, 1)ĭo While (Not c.Value Like "Summary*") And c. ' go up until find a content like "Summary*" 'get the first cell on the selected row, then Private Sub Worksheet_SelectionChange(ByVal Target As Range) Use the Split command to split your worksheet into multiple panes. Try opening a new window for your workbook. If you are using the example, freeze the top two rows (rows 1 and 2). One difficulty is that to scroll up you have to click on one of the rows in the top pane. If you want, you can use our practice workbook. Each time the selection changes, it checks upward in the first column for content like "Summary*": if the worksheet isn't already frozen to that row, it will make that adjustment. You can try this out (in the worksheet code module).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |