#Gembox spreadsheet get last used row how to#

#Gembox spreadsheet get last used row how to#

Similar: How to Count Until a Blank Row in Google Sheets If you have still doubt, I have a detailed tutorial on this. That means it only returns the number 9 in H10 as G10 is blank and in all the other cells, it returns FALSE.В The MIN function in this range returns the number 9. Because the formula only returns numbers wherever the cell value in G is blank.

When you use this formula independently, after removing the MIN, for example in H2, it may return serial number 1,2,3 starting from H2 to downwards.Д«ut the IF logical function may force the formula to put serial number only in H10. If you run the above code, you will get row number of last used cell. SpecialCells(xlCellTypeLastCell).Row Debug.Print lastRow End Sub. Sub spllastrow() lastRow ActiveSheet.Cells. Well go over several methods of getting the last row, including a. Using SpecialCells Function To Get Last Row The SpecialCells function with xlCellTypeLastCell argument returns the last used cell. =ArrayFormula(MIN(IF(G2:G='',ROW(G2:G)-ROW(G2)+1))) In this tutorial learn how to get the last row of data in Google Sheets using Apps Script. So any blank cell in this column possibly return a wrong result. The below formula is the main part here and here my primary column is G. ThisвЂ™s an entirely different approach.ДЄs you can see the main functions here inВ this example are ADDRESS, ARRAYFORMULA, MIN, IFВ and ROW. Here is one more formula to find the Cell Address of a last used cell in Google Sheets. Now we can use the Cell function вЂњaddressвЂќ info type to return the address of this cell containing the value 99. You can use the above Index formula to return the last cell value in a range. Result: 99 (the last cell value in the range in G9. Alternatively, the Cell formula returns Column number of G. You can directly put 7 as G represents column number 7. ItвЂ™s easy to find the column number as we know our last column in the data range is column G.