Excel Functions

[neilg]

Hi,

I am not sure if my post fit on this forum. In Microsoft Excel, How do i get the number of rows a worksheet have. For example, worksheet1 have 10,000 rows and worksheet2 have 5,000 rows. How could I get those values, what function could I use?

Thanks In Advance,
Neil

[Sahir]

For example, worksheet1 have 10,000 rows and worksheet2 have 5,000 rows. How could I get those values, what function could I use?
An Excel sheet always contains 65,536 rows and 256 columns. To determine how many contiguous rows contain data you need to iterate through the rows.

[ovidiucucu]

UsedRange property returns a Range object that represents the used range on the specified worksheet.
Here is a little example in VBA.
Dim nUsedRows As Integer, nUsedColumns As Integer

Worksheets("Sheet1").Activate
ActiveSheet.UsedRange.Select
nUsedRows = Selection.Rows.Count
nUsedColumns = Selection.Columns.Count

[neilg]

Thanks a lot ovidiu and sahir, I really appreciate your help. I will look into those functions.