Specify target cell
Hello. I am trying to get an output to a specific cell after change in any
cell in a range.
This code does what i want, except it offsets target next to cell.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("h5:h30"), Target) Is Nothing Then
Target.Offset(0, 1).Value = Target
End If
End Sub
How can I replace Target.Offset with only one specific cell for all change
in range?
Thanks in advance :)
|