Hell o, I'm getting this object required error, which I do not know what it means exactly.
The code I'm running is shown below:
I tried to insert Set before the error line but it did not work. Ant ideas how it is fixed and what object required error means?
The code I'm running is shown below:
Code:
Dim TestYear As Long, TestMonth As Long, TestDay As Long, TestDate As Date
TestDay = Day(TestDate)
TestMonth = Month(TestDate)
TestYear = Year(TestDate)
If IsEmpty(Sheets("Test Description").Range("D14")) Then
Sheets("Test Description").Select
Sheets("Test Description").Range("D14").Activate
Else
ActiveCell = ActiveCell.Offset(0, 1)
End If
ActiveCell.Value = TestYear
ActiveCell.Offset(1, 0).Value = TestMonth
[B] ActiceCell.Offset(2, 0).Value = TestDay[/B] 'This is the error line
End Sub
I tried to insert Set before the error line but it did not work. Ant ideas how it is fixed and what object required error means?