dcooper33
Lifetime Supporting Member + Moderator
That code won't work. I think you will get the first value in your array in all the cells. A For/Next loop will probably be your only option.
I went ahead with the for-next loop for the cell loading. It takes about 2.5 mins to read and load all the values, but it's just a spreadsheet for tracking production history, and only gets updated every week or so.
Looks like it will work just fine for what management is after.
Thanks again for all your help :site:
Cheers,
Dustin