View Single Post
  #3   Report Post  
KL
 
Posts: n/a
Default

....also I guess the first 4 instructions of your code can be reduced to one:

Sheet1.Rows("11:5000").ClearContents

Regards,
KL