Darren

I know that's a problem and I'm kind of trying to think if there's a way round it by taking a slightly different approach.

You can actually do it with arrays (or ranges) and List but that's a bit fiddly.

Any chance you could upload a sample workbook?