Forum Discussion
Go with use of a macro to other sheet and in the table in this sheet, go to first empty row
Thank you for your quick response.
It almost works. But the Sheet "Bezoeken"contains a table and with your code
Call GoToNextRow
Excel goes automatically to the last row of the table and not to the first available empty cell in the first empty row even when it is in a table.
Is that also possible to create? That when Excel opens, that Excel automatically goes to the first empty cal in the first empty row even this row is in a table?
So everytime someone filles in data in a row and Excel saves automatically the data or the Excel worksheet will be closed, and Excel will be started again, that the cursor goes to the first available cell in the first empty row in the sheet?
Hopefully that is possible.
Looking forward to your reply.
With regards,
Diana
Try this version:
Sub GoToNextRow()
Application.Goto Reference:=Worksheets("Bezoeken").Range("A1").End(xlDown).Offset(1), Scroll:=True
End Sub- Hoi Hans,
thank you for your help. It works.
With regards, (Groetjes)
Diana