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