I have a command button on a worksheet, which has the following code:

-----------------
Private Sub action_completed_Click()

Selection.Font.ColorIndex = 3

End Sub
-----------------

What I want this to do is change the font colour of the cell or cells I have currently selected to red. When I click the button it returns a runtime '1004' error...

What I'm a doing wrong??

Hope you can help

Thanks

Dave