Finding Last Row in Excel 1

[RonRepp]

Hi all:

Is there an easy way to find the last row in Excel? I seem to remember reading it--it might have been in this forum, but I searched to no avail.

Anyway, I've always looped through to find the first empty cell, like this:

Do
  Activecell.Offset(1,0).Activate
  If Activecell.Text = "" then Exit Do
Loop

Any help will be greatly appreciated, as this takes forever with a large spreadsheet.

Thanks,



Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[PHV]

There is at least 2 FAQs in this forum covering this subject.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[firefytr]

The FAQ's here have not been updated. Read Bob Phillips white paper here ...

http://www.xldynamic.com/source/xld.LastValue.html

-----------
Regards,
Zack Barresse

 

[RonRepp]

firefytr:

Thanks for taking the time to point me in the right direction.

Ron



Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[firefytr]

No problem at all.

I would also recommending taking note of PHV's post, there are some very good FAQ's here.

Take care!

-----------
Regards,
Zack Barresse