VBA; Go last Row Then Show Msg " Rows ....(depend last row founded)

[muhammad susanto]

hi all..

this code work properly but i want added message "Rows...." if last row founded for example Row 12 or Row 100 etc..
here this code:

Sub GoToLastRow()
endrow = [C10000].End(xlUp).Row ' count the last row number
Cells(endrow, 3).Select ' select cell column C and last row
End Sub

thank in advance

susanto

 

[Fluff]

How about

Sub GoToLastRow()
endrow = [C10000].End(xlUp).Row ' count the last row number
Cells(endrow, 3).Select ' select cell column C and last row
MsgBox "last row is " & Selection.Row
End Sub

 

[muhammad susanto]

hi Fluff, thank you.

 

[Fluff]

Glad to help & thanks for the feedback.