I have an array that I want to copy over to a cell range. The array is the same size as the cell range and everything works fine as long as all the array contains text of some kind, but as soon as at least one element is an empty string, I get an error message. Why isn't it possible to copy an empty string to a cell?
After defining Range the usual way, I use Range.setDataArray(MyArray()) to copy the strings over to the cell range. I also tried Range.setFormulaArray(MyArray()) with the same result. I know there isn't any kind of mismatch in size between MyArray and Range, because it works as long as no element of the array = "". I know how I can get around this, but I really don't think that it should be necessary. Is this a bug? Johnny Rosenberg --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
