View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dick HSV Dick HSV is offline
external usenet poster
 
Posts: 1
Default Delay when writing cell information to Excel from VBA Macro

When I loop through in VBA setting a value for a variable the loop goes
fast. When I use cell(i,j).value to put the value in a cell there is about a
1 second delay between each cell. For 250 cells it is a long wait. Is there
any way to control this wait?