My worksheet loks like

# Group FirstName LastName Scor

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

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.