Hello everyone. I have a piece of code that colors the contents of a
cell if the contents are hard-coded. This code as currently written
applies to the nentire sheet. I would like to apply this code to only
a specific range of cells. This will be used by end users, so ideally
I'd like then to push a button, which will then prpomt the user via a
form of some sort to select the range of cells. Can you help? Thanks
so much in advance!! Here's what I have now:

Sub ColorCellsRange()
On Error Resume Next
Cells.SpecialCells(xlCellTypeConstants, 1).Font.ColorIndex = 5
End Sub

-Steph