excel - Application.Evaluate vs. Activesheet.Evaluate -

excel - Application.Evaluate vs. Activesheet.Evaluate -

i reading thread a custom find function , stated

interesting result. note evaluate same application.evaluate , takes twice long activesheet.evaluate – chris neilsen

should 1 utilize activesheet.evaluate in place of application.evaluate?

thanks

i don't know if should, looks can. illustration these work:

activesheet.evaluate("2") activesheet.evaluate("sheet1!a1+sheet2!a1") activesheet.evaluate("sum([book1]sheet1!a1,[book1]sheet2!a1,[book2]sheet1!a1,[book2]sheet2!a1)")

the first case worksheet-agnostic, , returns right result in immediate window.

the sec refers 2 sheets , returns right result. third, refers 2 different workbooks.

the obvious caveat qualify worksheet or workbook references.

excel excel-vba