Sounds easy, I want to center the text in Column C. I was trying to use the following code but it failed:
With Sheets("TOC")
.Range("C:C").HorizontalAlignment = xlCenter
End With
Also tried to change the font color of Column B to black by using the following code but it failed:
With Sheets("TOC")
.Range("B:B").Font.Color = RGB(0, 0, 0)
End With
Thanks in advance
With Sheets("TOC")
.Range("C:C").HorizontalAlignment = xlCenter
End With
Also tried to change the font color of Column B to black by using the following code but it failed:
With Sheets("TOC")
.Range("B:B").Font.Color = RGB(0, 0, 0)
End With
Thanks in advance