Set rngLastCell = Sheet1.Range('A1').Offset( - 1, 0). You don't have to first get the row number, and then build the cell reference. Note that really, if you want the cell reference, you should just use the following. So for instance, if you take your example data and also write something in cell FY4763, the above will still correctly return 9 (not 4763, which any method involving the UsedRange property would incorrectly return).

This also works if you have data that go further down in other columns. .that manually, the cell pointer will be in the next empty cell in column A even if the data area doesn’t begin in row 1 and contains blank rows. This searches up from the bottom of column A for the first non-empty cell, and gets its row number. Or the equivalent but shorter numofrows = Sheet1.Cells(,1).End(xlUp) Here are formal limits as well, but practically its limited only by your memory size. Many of you requested that we improve the way this works, and that’s just what we’ve done. When you’re scrolling in a sheet with very large cells, the way Excel for Windows snapped to the grid made it hard to view your data. On the other hand you may load your data into data model and process them using Power View returning compact result into Excel sheet. The bold text in row 2 says 'Were happy to anounce New in Excel for Windows: Smooth Scrolling'. numofrows = Sheet1.Range('A1').Offset( - 1, 0).End(xlUp).Row No way, you cant expand Excel sheet limits. returns this number dependent on the version. Text Formats Stores data as string of texts. Percentage Stores numbers as a percentage. Currency Stores data in the form of currency.

The first has 65536 rows in a sheet, while the latter two have a million rows or so. Eleven data formats are available in Microsoft Excel for data Storage. This will work, independent of Excel version (2003, 2007, 2010).

Excel how many rows available in excel