Finding the last row in a Excel WorkSheet

[barnard89]

Hi

I am using Microsoft Excel 2000
The workbook has 3 worksheets .
Each sheet contains throusands of rows and it the number of rows
varies for each sheet

How can I find out the last row for each row ?
Is there a built in function or a command to find out the last row of an excel worksheet?

Even a macro also is acceptable

Please suggest

thanks

 

[TonyJollans]

Hi barnard89,

There are lots of ways to find the last row - what you do rather depends on where you want the result and how you want to use it. The implication in your post is that you don't want to use the result in a macro so what exactly do you want?

If you do want code, take a look at the FAQs - there are at least two on this subject.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[easynoweasy]

This will tell you the last row number for A. Replace A with the row you need.

A_variable= Cells(Rows.Count, "A").End(xlUp).Row