Thread: save results after N times macro run
View Single Post
  #1 (permalink)  
Old 06-02-2007, 11:13 AM
PeterKem PeterKem is offline
Junior Member
  
Join Date: Jun 2007
Posts: 6
Default save results after N times macro run
Hi,

Is there a way that I can save the results after runing macro for 1000 times and continue the rest of the macro ?

FYI: My macro is to copy a name from one cell of column1 in the Excel, run a picture creating program, paste the picture onto column2 of the same row. After repeating 1000 times, I would like the Macro to save the Excel file and continue to run the next 1000 times, and so on.

Thanks,
Reply With Quote