Copy paste dde values every minute

[Sarangsood]

I have live data feed of stocks in my excel sheet & i want to capture there values every minute. The code i'm using below freezes the sheet for few seconds. Is there a better or faster way to capture the values, as i'm using this code in the same workbook in other sheets with different time frames. Thanks

Please Login or Register  to view this content.

[mehmetcik]

This is probably where you are wasting time.

Please Login or Register  to view this content.

Try this. It copies pastes all 49 cells at once. So theoretically it should be 49 times faster.

Please Login or Register  to view this content.

[Sarangsood]

Hi. just tried the above mentioned code. it's showing run time error 91. after debug it's highlighting this line:

Please Login or Register  to view this content.