I have an Excel 2000 spreadsheet where C1 and D1 have
headings. Column C has contiguous data but the number of
data rows changes. Sometimes it is 300, sometimes 322 and
at yet others 600. (That is, C1:C601 has data).

If C1:C601 have data, I would like to select D2:D601. In
other words, I would like the starting point to be D2 and
the end point to depend on how much data C contains.

If someone can show me how to do this it would be greatly
appreciated. If someone could show me how to select data
based on the previous column (rather than limit it to C
and D)that would be even more helpful.

Thank you.

--Indu