VBA Function Help

[jrhelfrich]

I work with a proprietary XLA Add-In that retrieves data from a server. The function used to retrieve data places the data array in the cell of the function and the remaining cells (across/down) depending on settings.

Is there an easy way in VBA to force the results into the cell below or right of the formula cell? The formula remains dynamic which causes problems for sorting when the output starts in the formula cell itself.

Thanks,

JR

[Bob Phillips]

A function cannot write to the worksheet, it can only return a result.