VBA code to set text color in an entire column & draw border (not a border grid)

[wrecclesham]

I'm trying to achieve two things using VBA code:

• set all text entered in column C to red
• draw a thick-lined border around cells A1:B2 without any internal grid lines

Any ideas?

Thanks!

 

[jimrward]

Have you tried recording a macro whilst manually doing the above

 

[mumps]

Try:

Sub wrecclasham()
    Range("A1:B2").BorderAround , xlThick
    Range("C1", Range("C" & Rows.Count).End(xlUp)).Font.Color = vbRed
End Sub

 

[wrecclesham]

Have you tried recording a macro whilst manually doing the above

Good idea. I'll see what I get when I do that.

 

[wrecclesham]

Try:

Sub wrecclasham()
    Range("A1:B2").BorderAround , xlThick
    Range("C1", Range("C" & Rows.Count).End(xlUp)).Font.Color = vbRed
End Sub

Works beautifully. Thank you very much!

 

[mumps]

You are very welcome.