Home Excel VB/VBA Last Row Containing Data
20 | 05 | 2012
This site has been updated and renewed. You have followed an old link.

Click here to go to the new site

http://www.visiblevisual.com/jupgrade
Last Row Containing Data PDF Print E-mail
User Rating: / 0
PoorBest 
Tutorials

This code displays the last row that contains data

[code]

 
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
[/code]

< Prev   Next >
 

Add comment

Security code
Refresh

This site has been updated and renewed. You have followed an old link.

Click here to go to the new site

http://www.visiblevisual.com/jupgrade