I’m trying to bold all cells in my column A range if the cell value starts with 5 spaces. Currently this is what I’m trying; producing the error code: Run-time error '13': Type mismatch
Sub Bold ()
Set BoldRange = Sheets("Formatted Data").Range("A13:A100000")
If BoldRange.Value Like " *" Then
BoldRange.Font.Bold = True
End If
End Sub
Note, the error is occurring on line If BoldRange.Value Like " *" Then