Matt
Obviously if you cycle through less items, it will run quicker. If
ArrayB is a table on a sheet, you can divide each element of the table by a
simple copy - PasteSpecial - Divide. HTH Otto

"Matt S" wrote in message
...
I have this code right now:

For ii = 1 to 100
arrayA(ii) = arrayB(ii) / 10^4
Next ii

Is there a way to do this calculation faster? Maybe without cycling thru
all elements of arrayA?

Thanks,
Matt