I was looking at this article: http://www.vbaexpress.com/kb/getarticle.php?kb_id=279
The code they use to call the function is:
I modified the function to look like this as I do not return a value with my subroutine:MyResult = Application.Run(wbTarget.Name & "!Functionname", 1, 2)
Application.Run macros.xls!sampleMacro( WBName, SheetName, ColumnLetter)
and I received this error, "Object Required". Where is my syntax wrong?
Bookmarks