VBA get last row of active sheet

[MM91]

Hi I am new to excel and am having trouble with getting last row of active sheet. I have done it before recently and I cant find what the issue is. Also any suggestions on how to make it more effecient are appreciated!



Sub AddRowActiveBottom()

Range(Rows.Count,1).End(xlDown)).EntireRow.Insert

End Sub

 

[rlv01]

Not sure what you are after. The last row of the active sheet is always row 1048576 because that's the max allowable size. Do you mean the last non-empty row?. Also, why to you want to insert instead of just moving to the first empty row?

 

[jolivanes]

Cells(Rows.Count, 1).End(xlUp).EntireRow.Insert

 

[Akbarov]

= Cells.Find("*", , xlValues, , xlRows, xlPrevious).Row

To find last non-empty row