error object required. Can someone help me to fix this?
Do While 0 < Count
If Task.Finish > DateTime.Now Then
Font Color:=1
End If
Loop
error object required. Can someone help me to fix this?
Do While 0 < Count
If Task.Finish > DateTime.Now Then
Font Color:=1
End If
Loop
Step through the code to determine the actual error. Use the Watch window to check values. My guess is you need to define what Font refers to.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Can you post you project with a small explanation of how you invoke the code?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber