Going last line of the excel sheet

0

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?

Answer
Discuss

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 Sub

You 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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login