View Single Post
 
Old 06-05-2015, 08:47 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Am I missing something ?
Wouldn't this suffice ?
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Intersect(Target, Range("E16:I18")) Is Nothing Or Target.Cells.Count > 1 Then
    Exit Sub
Else
    Range("M1").Value = Target.Value
End If

End Sub
Reply With Quote