Depends on which Excel version you are using:

see http://www.decisionmodels.com/calcsecretsg.htm for more details

Charles

wrote:

hi all!
i have this question to be sure about..

when i place in my vbe code this line..

Range ("B2:E2").Calculate

will the calculation be linear ..
first B2 then C2 , D2 , E2 ??

tx !!