Hi folks,

Just a query, I need to replace a text in vba code with another text and make it bold. The code I am using is...

With ActiveSheet.UsedRange.Columns(2)
.Replace "Do you have IT systems availability?", "Availability"
End With

The above code is working fine in replacing the text but not getting on how to make the font of the replaced text "Availability" bold. Can somebody help me please?

Thanks in advance...
Abhi