Evaluate Method Example

This example turns on bold formatting in cell A1 on Sheet1.

Worksheets("Sheet1").Activate
boldCell = "A1"
Application.Evaluate(boldCell).Font.Bold = True