Hello, Im developing a calender program using macros. One of the things that this calender should do is if an activity of a table is complete and change their font to red. The same thing must happen in the calender which is in other worksheet. My main problem is to covert a variable font. Does any body knows how to do it?
Cont(0) = Sheet2.Cells(Fnd.Row, 2).Value
Cont(1) = Sheet2.Cells(2, Fnd.Column).Value
A = Join(Cont, " ")
If Sheet2.Cells(Fnd.Row, Fnad.Column).Font.ColorIndex = 3 Then
A.Characters.Font.ColorIndex = 3
End If
Here is what I try, A is the string variable that I want to change de color, but compile error continues.