Thanks, this one almost did it, the user can select multiple rows and
this only selects the last row in the selection.
Range(Cells(ActiveCell.Row, "B"), Cells(ActiveCell.Row, "E")).Select
but it selects the right columns which will come in useful!!!