Thread: Copying Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sabo, Eric Sabo, Eric is offline
external usenet poster
 
Posts: 10
Default 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!