Hi Dan,

This sounds as if your code is a bit "enthusiastic" & is overwriting the data you want with blank strings. As you're using a multi-dimensional array, the first thing I'd look at is any FOR-NEXT loops that write data to your worksheet. I'd be surprised if anything associated with the variable type would produce the result you describe.

I'm happy to have a look at your workbook if you'd care to post it.

Regards,

Greg M