D
Dreiding
My problem is worksheet code "worksheet_change" does not allow usage of a
named range thatis in another worksheet.
Example code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Start As Variant
If Target.Address = Range("A1").Address Then
Range("A4").Value = Range("myDate").Offset(Range("A1").Value - 1,
0).Resize(1, 1).Value
End If
End Sub
This code is behind worksheet1, the range "myDate" is in worksheet2
Any suggestions?
named range thatis in another worksheet.
Example code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Start As Variant
If Target.Address = Range("A1").Address Then
Range("A4").Value = Range("myDate").Offset(Range("A1").Value - 1,
0).Resize(1, 1).Value
End If
End Sub
This code is behind worksheet1, the range "myDate" is in worksheet2
Any suggestions?