Solved: What are the differences between two?

[YellowLabPro]

I found these two examples in the help section: what are the differences? I do not understand what Evaluate is doing. The definition is-
"Converts a Microsoft Excel name to an object or a value"

Sub test2()
Worksheets("sheet1").Activate
boldCell = "A1:C5"
Evaluate(boldCell).Font.Bold = True
End Sub

Sub Test3()
Worksheets("Sheet1").Range("A1:C5").Font.Bold = True
End Sub

Thanks,

YLP

[Bob Phillips]

There is no difference between the end result in the two examples.

The Evaluate method takes a string argument and returns the object or value that the string refers to. It is also pretty inefficient and should be avoided unless there is no other option, which is not the case here.

[YellowLabPro]

Hi Xld,
What makes it inefficient?

[Bob Phillips]

The amount of work that has to gon, the string has to be parsed, checked for validity, and then evaluated. Referencing the object directly avoids all of this.

[YellowLabPro]

Ok....

Thanks