Im using ADO to return a recordset to my Data Grid, and am familliar with the following code snippet that will return my current selection:

Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)

Debug.Print DataGrid1.Text; DataGrid1.Row; DataGrid1.Col

End Sub


However I'd much rather use the traditional, select the first row and hold down the shift key and select the last record... and return the range. Im sure this is easier than Im thinking (ok, Im hopeful at least).

Thanks in advance,
Brent
(or Hopeful in SF *grin*)