Hello!
I copied my code hereunder.
When I run it, Visual Basic stops at the "b.select" line and give me the following error message:
"Select method of Range class failed"
I just can't understand why...anyone can help?
Thanks
Louis
I copied my code hereunder.
When I run it, Visual Basic stops at the "b.select" line and give me the following error message:
"Select method of Range class failed"
I just can't understand why...anyone can help?
Thanks
Louis
Code:
Sub ActivatePeriod()
Dim c As Range
Dim b As Range
PeriodOpeningDate = Evaluate("DATE(YEAR(NAVDate),MONTH(NAVDate),1)")
PeriodEndingDate = Range("NAVDate").Value
For Each c In Range("FSLockLookUpRange")
If IsDate(c.Value) Then
If c.Value >= PeriodOpeningDate And c.Value <= PeriodEndingDate Then
For Each b In c.EntireRow
If b.Interior.ColorIndex = xlNone Then
b.Select
Selection.Locked = False
Else
b.Select
Selection.Locked = True
End If
Next
End If
If c.Value > PeriodEndingDate Then
c.EntireRow.Hidden = True
Else
c.EntireRow.Hidden = False
End If
Else
End If
Next
End sub