Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is my macro - why am I getting an object required error?
Sub HolidaySelection() Dim i As Long Dim j As Long Range("startpoint").Select For i = 1 To 12 For j = 1 To 28 If Application.WorksheetFunction.CountIf(Worksheets(" Holidays").Range("F5:F13").Value, DateSerial(Range("VacYear").Value, i, j)) Then ActiveCell.Offset(i, j) = "H" End If Next j Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Object Required Error | Excel Programming | |||
Object required error 424 why getting? | Excel Programming | |||
Object Required Error | Excel Programming | |||
424 Object required error | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |