YellowLabPro
03-14-2007, 08:42 PM
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
"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