MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to get worksheet function to return data to other cells

Posted by Marty on June 27, 2001 9:15 AM

I would like to write a worksheet function that returns data to other cells. One of the arguments is the starting cell location to return the data. The other arguments specify the remote data source. How can you get a worksheet function to do this. I know it can be done - I have a product suite with that includes an excel addin that does just this - but it is password protected so I cannot see the code.

Posted by Russell on June 27, 2001 10:25 AM

Can you be a bit more specific about what you would like the result of your function to be? Maybe give an example....

Posted by Joe Was on June 27, 2001 10:58 AM

Where, myData is a value, function result or a "Set" ( Set myData = Worksheets("Sheet1").Range("A1")
Or what ever. JSW