Dear,
I have a excel sheet of 200 lines. After closing the file and when re opening the cursor will be at the first line. Instead of being there is it possible the cursor be at the last line where the entry is made?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Going last line of the excel sheet
0
Answers
0
If you save the file after selecting the last row, then it should open at that last row again.
However, you could use a more complex method, a macro.
Private Sub Workbook_Open()
Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Select
End SubYou put this into ThisWorkbook in the VBA window and not into a worksheet or module. Sheet1 is the sheet that you want to see and A is the column that it checks for the last row.