I am having issues limiting the last row in excel.
I want it to only allow and display at most 121 rows.
what i have is
Dim lastrow As Integer
lastrow = Worksheets("Broad").Range("A122").End(xlUp).Row
but it seems that it doesn't work, like when i press down on the keyboard it just keeps going...