hello
i try to exclude one range from another range.
i want to exclude range fd from range a. any solution?
i try to exclude one range from another range.
Code:
Sub ddt()
Dim fd As Range, a As Range
Set a = Range(Cells(1, 1), Cells(20, 10))
Set fd = Cells(7, 5)
Set a = a - fd
a.Value = 1
End Sub