Best way to copy value from one range to other

[cwng3]

Hi,

I have a spreadsheet to which has to
1/ copy some data from another spreadsheet
2/ copy some data from other cell with formula in the same spreadsheet

For 1/, the existing macro is to open the external spreadsheet and copy the value

For 2/, we are just using range.select, range.copy and then range copy and paste value function

As a result, it cause lots of screen refreshing and spend lot of time.

Is there any better way to do these ?

Thanks a lot.

Tom

 

[cwng3]

Yes I know but the problem is that when two people access the same macro at the same time it will cause locking problem. mmm. of course, the probability is very low.

Thanks