Hi
very difficult to give solutions or suggestions without seeing the
code.
If your function can have 2 sorts of output, make it return a variant
and see how that goes.
The range problem is impossible to diagnose without code. Range
selection is always a nuisance when you are switching between sheets as
you read and write data.

regards
Paul