vbe or worksheet function for cpu saving ??

P

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
 
T

The Code Cage Team

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

pls123;187418 said:
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
Click to expand...

--
The Code Cage Tea

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