I have a character array in a VBA program, I need to write only part of it (1..n) to a file. I’ve tried resizing the array just before the write, but that erases all the data. Is there a neater way than creating a second array of the required length and moving everything across?