I have this code which repeats itself to accomodate different ranges - about 20 when im finished.
Is there a better way of doing it using maybe Case statements?
thanks
Sally
If Not Intersect(Target, Range("dType")) Is Nothing Then
Sheets("variables").Range("qType").Value = Target.Value
Range("A1").Select
ElseIf Not Intersect(Target, Range("dDate")) Is Nothing Then
Sheets("variables").Range("qDate").Value = Target.Value
Range("A1").Select
ElseIf Not Intersect(Target, Range("dClass")) Is Nothing Then
Sheets("variables").Range("qClass").Value = Target.Value
Range("A1").Select
End If
Bookmarks