Copying Data
 

Excel 2003

I have the following data:

START
1 4 5 6 7 4
2 3 7 9 8 7
4 5 6 6 7 2


How would one write code to determine the end of the data or the range of
data? Let say "START" is in A5. How would I determine that the range
of data is A6:F8?

Sometimes this data will be larger and sometimes it will be smaller.


Thanks!

Copying Data
 

You can approach it from the top or the bottom.
From the top:

Last_Row = Range("A5").End(xlDown).Row

From the bottom

Last_Row = Range("A65000").End(xlUp).Row

Sabo, Eric wrote:
Excel 2003

I have the following data:

START
1 4 5 6 7 4
2 3 7 9 8 7
4 5 6 6 7 2


How would one write code to determine the end of the data or the range of
data? Let say "START" is in A5. How would I determine that the range
of data is A6:F8?

Sometimes this data will be larger and sometimes it will be smaller.


Thanks!