Selecting range

  • Thread starter Thread starter Indu Aronson
  • Start date Start date
I

Indu Aronson

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
 
See if this helps
Sub myarea()
x = Cells(Rows.Count, "c").End(xlUp).Row
Range(Cells(2, "d"), Cells(x, "d")).Select
End Sub
 
Try this piece of code:

Range("C2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Offset(0,1).Select

Nikos
 
Don and Nikos thank you very much for your help. Both
versions work just the way I wanted it to. Thanks again.
 
Back
Top