|
|
#14
06-05-2015, 08:47 AM
|
|||
|
|||
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Result Calculator
|
Raza | Excel Programming | 7 | 01-26-2015 11:35 PM |
| Excel Calculator | Mandusin | Excel | 6 | 12-25-2010 07:34 AM |
| Age Calculator in MS Outlook 2002 SP3 | turns | Outlook | 0 | 06-15-2010 12:26 AM |
| **FIND OUT WHO WAS BCC(BLIND CARBON COPIED) ON YOUR EMAILS?? | sharpescalade | Outlook | 1 | 11-30-2006 08:07 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode