Visual basic how many rows

Dim column As DataColumn. For Each table In dataSet. For Each column In table. If column. For Each row In table. End If. Next row. Next column. Next table. Saturday, March 24, PM. I personally don't have time to look at your project. Count Reed Kimble - "When you do things right, people won't be sure you've done anything at all".

Please help? Did you get rid of the loops? Count TextBox2. Columns Remove the For Each loop for dataset. Thanks for your relies. I did that but I've got the results of all table rows number. Hello, It's actually easy to get the count for any table that has a specific column name but on a side note would not name a DataColumn name with any spaces. OfType Of DataTable. ToList return results. Where Function item item. Contains pColumnName.

Add dt1 ds. Add dt2 ds. Tables item. What type of database are you working with? Many thanks! Sunday, March 25, AM. Hi AnAnnn, If you have solved your issue now, please remember to close your thread by marking the helpful post as answer, it is beneficial to other community members who face the same issue. Thanks for your understanding. In procedures, the end statement is used to end a subprocedure or any loop function, such as 'End if'.

This will take you to the last cell before any break, now in the active cell Active Cell The active cell is the currently selected cell in a worksheet. Active cell in VBA can be used as a reference to move to another cell or change the properties of the same active cell or the cell's reference provided from the active cell.

Ok, done. Finding the last used row is so important to decide how many times the loop has to run and also in the above method the last row stops to select if there is any breakpoint cell, so in this method, we can find the last used row without any problems.

In VBA concepts, cells are also the same, no different from normal excel cells. Now we need to mention the row number to start with, the problem here is we are not sure how many rows of data we have, so what we can do is we straight away go to the last row of the worksheet, for this mention ROWS. COUNT property. Next, we need to mention in which column we are finding the last used row, so in this case, we are finding in the first column, so mention 1.

At this moment, it will take you to the last cell of the first column, from there onwards we need to move upwards to go the last used cell, so use End xlUp property. It helped for me also.. NET VB. Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation.

This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace. Remember Me? Advertiser Disclosure. Advanced Search.