row maximum

  1. E

    Setting the last Row

    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...
  2. B

    Rows of data lost after closing an excel file

    I am bringing data from Microsoft Access into Excel 2003. When I paste the data in, all the data I have copied is there in Excel. After saving my worksheet all the data is still there. If I close out of the Excel file and re-open it I only have 16,110 rows of data. The rest is gone. It is...

Some videos you may like

This Week's Hot Topics