Hi Renderman,

Can you not use Selection.Count to redim your array and as an upper
limit to any loops your function might use?

While you're at it you may want to check that Areas.Count is only 1
unless your function can cope with multiple areas.

Without seeing the function code I can't tell if this will be of any
help to you.

NickH