I would like to create a sort macro for a range of cells that can vary in
length. The length is dependent upon a list the user pastes into another
tab. In my working tab I have references to the pasted tab for up to 200
entries. The user might paste anywhere from 6 to nearly 200 lines into the
paste tab. Then those entries show up in my work tab. The entries are
reorganized into 8 columns, so I know the start of the range is always A8 and
the end of the range is always H something.

2 questions.
1. What is the easiest formula to check for the end of the range I want to
sort? I know the value in cell A of the row following the last row will be
Zero and no cells above it will have this value.

2. How do I insert that formula into the range statement in VBA so that the
sort will operate only down to the row with the last value in it?

Thanks in advance for any assistance you can provide.
ed