How to select multi offset cells in range?Anyone advice me...Thanks.
Private Sub Worksheet_Change(ByVal Target As Range)
With Range("combin_oth")
If Target = .value Then
Target.Copy: Range(".Offset(-8, 37).value, .Offset(-4, 37).value, .Offset(1, 37).value").PasteSpecial...