Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("A1:C1") If Intersect(r, Target) Is Nothing Then Exit Sub Application.EnableEvents = False r.Value = Target.Value Application.EnableEvents = True End Sub I would like to target on specific cells rather than range. Could anyone tell me how to modify Range("A1:C1") into different cells? such as A13, A67, A100. Thank everyone for any suggestions Eric |