Last row in spreadseet



Hi guys

In my spread*** I have a list of names starting at G4 and continuning
along row 4. Underneath each name in row 5 is which group they are in e.g.
A, B, C, etc. Is there a way that I can programtically:-
1) Check which is the last row of the spread***
2) Select everybody who is in group C

Thanks
Tony


.