If you need to use a VBA procedure to write values to a range, most people would probably create a loop and write the values one cell at a time. Like this: [crayon-663b3ddd1dc74693959662/] >On my system, writing 100,000 values using a loop takes 9.73 seconds. A faster way to accomplish the task is to put … Continue reading Writing To A Range Using VBA