Dear All,
I am using the below code which works perfectly in same sheet. But instead of range a1 and b1 in the same sheet (bold one), i want to use range a1 and b1 of sheet2. Range "Nazim" is named range in sheet1. And this code will be put in sheet1.
Thks![]()
Private Sub Worksheet_selectionChange(ByVal Target As Range) If Not Intersect(Target, Range("nazim")) Is Nothing Then Range("a1").Value = Target.Value Range("b1").Value = Target.Offset(, 1).Value End If End Sub
Nazim
Bookmarks