Returning a range from a function

  • Thread starter Thread starter Avery Salter
  • Start date Start date
A

Avery Salter

I'm new to VB macros....

I'd like to create a function that returns data to a range of cells
instead of just one cell. Does anyone know how this would be
accomplished? Or should I be using a Sub? Is that easier?

Thanks!
 
Array entering the function into a range of the size required to
accommodate the output should work.

Alan Beban
 
I don't know what you mean by "I am specifying the range of cells I'd
like it to output to . . ." It's not in your code (nor would I expect
it to be), so we can't see what you mean.

In any event, if you're calling the function from a worksheet you should
array enter it into the range to which you want the output returned.

Alan Beban
 
Alan Beban said:
I don't know what you mean by "I am specifying the range of cells I'd
like it to output to . . ." It's not in your code (nor would I expect
it to be), so we can't see what you mean.

In any event, if you're calling the function from a worksheet you should
array enter it into the range to which you want the output returned.

Alan Beban
Click to expand...

Thank you all for your helpful efforts. I've decided since posting
that I'll try a different approach to solve my problem. So far it
seems successful. I have found that trying to explain what I'm doing
through text is much more difficult than I had anticipated; this is
most likely because I'm still new to the excel terminology and can't
articulate my actions to the extent that I need to. (Plus I'm getting
way too much spam.) Thanks again for your support!
 
Back
Top