Find & view last row

[iPete]

Hi all,

I've attached a macro to a button that opens another tab, finds the last row in a column + 1, enters some text and provides some guidance via a pop up message.

However I need the user to be taken to this row instead of having to scroll down, is this possible?

Sub New_Issue()
'
' New_Issue Macro
'

'
Sheets("Table").Select
Lastrow = ActiveSheet.Cells(Rows.Count, "F").End(xlUp).Row
Range("Table!F" & Lastrow + 1).Value = "New"
MsgBox "Please complete Columns G to F (Blue)"


End Sub

 

[Sektor]

Range("Table!F" & Lastrow + 1)[B][COLOR="Red"].Activate[/COLOR][/B]

 

[iPete]

Thank you very much!