range calculate in vbe
 

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

range calculate in vbe
 

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

range calculate in vbe
 

I believe it depends on dependencies.
For example:
If B2 has a formula of =E2*10, then E2 will be evaluated before B2.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



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

range calculate in vbe
 

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

tx all!



"Charles Williams" wrote:

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