22 | 06 | 2017

Last Row Containing Data

This code displays the last row that contains data

Sub LastRow()
    '****************************************
    '*** Code from VisibleVisual.com ********
    '****************************************
 
    Dim ix As Long
    ix = ActiveSheet.UsedRange.Row - 1 + ActiveSheet.UsedRange.Rows.count
 
    MsgBox ix  'Display the last used row
 
End Sub
Login

Sign up now and upload your code to the website.

Help us to continue.....
Statistics
Articles View Hits
2284664
Latest Articles