Hi,

I am using a VBA addin to get data from a database. The user selects a
cell then enters a function name with parameters in the formula bar.
This retrieves the data from the database based on what was specified.

The problem I'm having is that the user must know beforehand what the
size of the results will be or at least guess at it. This requires the
user to select a large range of cells and run the formula over the
entire range.

The ideal solution would be for the user to select a single cell, run
the query and the addin would then extend the range to accommodate the
result set.

So far I have tried to achieve this and failed. I have looked around a
lot online and found no solution to this. Can anyone help me out here,
any solution to this would be very much appreciated.

Thanks,

-Pete