I was wondering if had any suggestions for the fastest way to write values to discontiguous cells.
I know you can write to a single range really fast using a 2D array for objects (e.g. ($A$1:$B$20)
var range = cells.CreateRange(0, 0, 20, 2); range.Value = new object[,].....
My question is, how to write to a discontiguous range quickly all in one go? Something like:
Do I have to loop through each range in the area and set those individually?