The wired thing is the following. At Excel, at the edit-formula text box, I cut the text “Sheet2” and then paste it at the same place within the string, hit enter, and the error is gone, and the formula produces the expected result.
Curious thing is that, after the robot is finished, and I open manually the Excel file, the two ’ do not show at Excel. If a manually insert the two ', then the formula produces it expected result.
Thanks @Manjuts90. Still doesn’t work, here the sample excel file. At sheet VL06O, cells E2:E100 have the formula typed by the robot. The cell shows the NAME? error.