range calculate in vbe

  • Thread starter Thread starter pls123
  • Start date Start date
P

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 !!
 
I believe it depends on dependencies.
For example:
If B2 has a formula of =E2*10, then E2 will be evaluated before B2.
 
yeye ty
i knew the thing about dependencies but didn't know
if it was the same when calculating from vbe

tx all!
 
Back
Top