range calculate in vbe

[pls123]

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 !!

 

[Charles Williams]

Depends on which Excel version you are using:

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

Charles

 

[Gary Brown]

I believe it depends on dependencies.
For example:
If B2 has a formula of =E2*10, then E2 will be evaluated before B2.

 

[pls123]

yeye ty
i knew the thing about dependencies but didn't know
if it was the same when calculating from vbe

tx all!