![]() 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 Do not press ALT + W + F + R in a hurry hold on for a moment. We could just freeze the top row or just freeze the first column. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Step 2: Remember we are not only freezing the top row, but we are freezing multiple rows at a time. Then go to the View tab under the Window section and click on Freeze Panes. One difficulty is that to scroll up you have to click on one of the rows in the top pane. 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. |