On Sunday, August 27, 2017 at 2:21:30 AM UTC-7, GS wrote:
Select Case Target.Address
Case "I13": Range("ABC").Select
Case "I14": Range("DEF").Select
'and so on...
End Select 'Case Target.Address

--
Garry


Hi Garry,

Had to add the (False, False) to Target.Address(0, 0), works great, pretty compact code also.

Thanks, Howard