MS Excel Last record

[strangeBrew12]

I want to be able to find where the last cell that has data in it using a macro. Similar to using the <Ctrl> <End> key combination.

I would like to select a starting point and then go to the end of the data set. It will span multiple columns and the rows will vary each time.

Thanks

JJ

 

[PHV]

At least two FAQs in this forum cover 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

 

[abaldwin]

How is your "data" laid out. How will you identify what constitutes the last cell with data?

In other words
A B C D
1 2 3
6 7 8 8

As from the example above, The first row is missing data in column d. We would need some way of id'ing what is actually data and what is not.

This problem can easily be solved with basic looping and dynamically asking for the width of the data.

I guess I am asking for more information and an example of your data.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[strangeBrew12]

In case anyone else decides to look this up, the faq for this forum to check is faq707-2115