I have this:
dim buf(1500) as double
' do something here
Range("Q6:Q1505").Value = buf <-- will this work?
I want to copy the buf array into a range in one swoop, is this possible, or do I need to loop thru each array element and place it in a cell?
Also, as a general rule, is it quicker to do calculations in VBA and put them back in cells, or is it better to have individual cells have their own formulas? I have a big spreadsheet and I am trying to reduce recalc time.
thanks
Fred
dim buf(1500) as double
' do something here
Range("Q6:Q1505").Value = buf <-- will this work?
I want to copy the buf array into a range in one swoop, is this possible, or do I need to loop thru each array element and place it in a cell?
Also, as a general rule, is it quicker to do calculations in VBA and put them back in cells, or is it better to have individual cells have their own formulas? I have a big spreadsheet and I am trying to reduce recalc time.
thanks
Fred