Quick question - is there an easy way to find which row is the last with data?

[Scott Lyon]

I've got a spreadsheet that's set up with (for example) 1000 rows (with
properties set for those 1000 rows). But likely only a few hundred of those
will actually contain data (the rest will be blank).

Is there an easy way (in VBA) to find which row has the last non-blank data?

At first I thought I'd use:

ActiveSheet.UsedRange.Rows.Count


Unfortunately, that seems to be returning my 1000 rows every time (even if
the "real" data is only up to row 200).

I'd rather not build a for...next loop to find it, as that'd be horrifically
slow.

Any ideas?


Thanks!
-Scott

 

[Alan Beban]

Go to

http://groups.google.com/advanced_group_search

and search for

Last cell in range

Alan Beban

 

[Scott Lyon]

That worked nicely! And quick too!

Thanks, Chip!

-Scott