Hi,

I have this code here for a selectionchange event on one of my
worksheets.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range(Cells(Target.Row, 4), _
Cells(Target.Row + Target.Rows.Count - 1, 30)).Select
End Sub

This works great as long as the range I want is contiguous. How would
I go about changing this code to only keep selected rows if the user
holds the CTRL key and selects random rows? I don't know if this is
even possible but I've played with the intersect method and this
doesn't seem to be a solution.
Any input is appreciated.

Thanks,
Mjack


--
mjack003
------------------------------------------------------------------------
mjack003's Profile: http://www.excelforum.com/member.php...fo&userid=5141
View this thread: http://www.excelforum.com/showthread...hreadid=539927