Returning multiple values on vba with a function
Posted on 2011-09-14
I have a function, which is a web query. It gets the table from internet and pastes it on Cell E111.
The information I need is on Cells F111 and F114.
so after the webquery I tried something like this and didnt work
myfunction = b(Sheets("LiveSheet").Range("F111").Value, Sheets("LiveSheet").Range("F114").Value)
I need to put the values, i return from the function into two different cells on excel.
Also the function is used in a vba subroutine.