Hi!

I have a bit of a bizarre problem, and before I upload the workbook for people to look at, I'd like to see if this is problem that can be easily fixed just by someone hearing the issue:

I have a multi-dimensional array full of strings that I am writing to a range of several consecutive entire rows. When I run the macro, I see the values paste over the range momentarily the way I would like, but only for an instant because a split-second later the entire range is BLANK. All the cells in my range are immediately erased...and there is no more code in my macro after this part that could be doing it.

I've tried making the array of variant type and string type, and when I store strings into the array (that I get from other cells in the workbook) before I write it to the range, I've tried storing cell formulas and cell values.

Any suggestions? If this doesn't help, I can upload the workbook.

Thanks!

Dan