Assuming that the column is C:

ActiveSheet.Range("C65536").End(xlup).Select

This will select the last cell in that column that has a
value. The statement does the same as if you were go to
the last cell in column C and then click Ctrl+Up Arrow.


tod

-----Original Message-----
My worksheet loks like:

# Group FirstName LastName Score

1 A John Jones 9
2 A Bill Brown 8
3 A Sue Harper 8
4 A Mary Rae 7
5 A Sal Pacino 4
6 A
7 A
8 A


My data varies from 200 rows to 250 rows and I need to
peform a Selection.End(xlDown).Select in the FirstName
column (to Sal), then go down 1 more row and select the
contents of the # and Group columns (from 6 A to 8 A).
Then I need to clear the contents of these cells.

Any help would be greatly welcomed.
.