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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top