vbe or worksheet function for cpu saving ??

[pls123]

hi all !! i use manual calculation..
i have to save cpu usage for multiple simoultaneous evaluation with looping
macros..
...to copy some values from a main page..
should i use ..this ...??

aWS.Range("N31").Value =
Workbooks("@@@@PLT@@@@.xlsm").Sheets("Sheet1").Range("K37").Value

or this ??

='[@@@@PLT@@@@.xlsm]Sheet1'!$K$37
+ range calculate
of that cell

 

[The Code Cage Team]

In my opinion, Excels built in functions are more efficient at carryin
out that calculation.

hi all !! i use manual calculation..
i have to save cpu usage for multiple simoultaneous evaluation wit
looping
macros..
...to copy some values from a main page..
should i use ..this ...??

aWS.Range("N31").Value =
Workbooks("@@@@PLT@@@@.xlsm").Sheets("Sheet1").Range("K37").Value

or this ??

='[@@@@PLT@@@@.xlsm]Sheet1'!$K$37
+ range calculate
of that cel

--
The Code Cage Tea

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com