Speaking personally, I would go for #2. I try to avoid interacting with the
worksheet/workbook until I have to

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
just a general question, is there a preferred method?

if i use an array or loop to get numbers, sum those numbers and then place
the
sum in the cell, is it better to:

1. put each value in the cell and add each subsequent value to it or,
2. store the numbers in a variable and then just place the value of the
variable
in the cell when it's complete?

in this instance, there's no real speed issue, it takes a second to do
what i'm
doing, but just curious what the professionals do.
--


Gary