View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Under Pressure Under Pressure is offline
external usenet poster
 
Posts: 22
Default Speed the macro works

I am relatively new to macro writing. I have written a macro that copies 30
lines of a spreadsheet ( this is a template for student report ) 300 times
into the rows below it. Works fine at first, quite fast as one wouls expect.
However, as more sections of the 30 lines are copied, it goes slower and
slower and takes the best part of 20mins to complete. Any suggestions?

Under Pressure