My guess is that it is not a range but an array. That's why xl doesn't allowit. Maybe make a range on a hidden sheet?