I can't believe I'm here for this...but I can't get this to work
The value in "D4" is a date - The error I'm getting is an 'Object Required' Error on the Set Rng1... line
Clearly I'm missing something - but I'm not seeing it
Thanks in advance for the humility about to come my way
Code:
Dim Rng As Range
Dim Rng1 As Range
Set Rng = Worksheets("Sheet1").Range("D4")
Set Rng1 = Worksheets("Sheet1").Range("D4") - 2
The value in "D4" is a date - The error I'm getting is an 'Object Required' Error on the Set Rng1... line
Clearly I'm missing something - but I'm not seeing it
Thanks in advance for the humility about to come my way
