Function Return Range

[goss]

Hi all,

Using Excel 2010.

Trying to return a Range Object from a Function, but I receive "Object Required" from the calling Sub().

I printed the Range Address from the Function that means the Range exists, at least in the Function.

Thoughts on what I am doing wrong?

thx
w

debug.print output

rng $A$1:$N$7602
GetExcelRangeFunc $A$1:$N$7602

Please Login or Register  to view this content.

[shg]

A range object refers to a range in an open workbook; your sub closes the workbook before exiting.

[goss]

Thanks Shg,

Revised Function below.
The lesson learned: keep Function really simple to a singular purpose.

thx
w

Please Login or Register  to view this content.

[shg]

Good job.

Or, more compactly,

Please Login or Register  to view this content.