How to return more than one value

[aziz rasul]

Can anyone demonstrate how a function can return more than one value, assuming that this is possible.

 

[KDg]

Hi aziz,

by default VB passes arguments/parameters by reference ( you can also make this explicit if you want, which is a good idea for maintainance ), anything you do to the var in your function will directly alter the one you passed in - they are pointing to the same piece of memory,

HTH

Drew

 

[aziz rasul]

Thank you both for your contributions.

Pat can you give me an example. I'm new to VBA and hence probably will struggle with it.