title: Why UserForm is "Not Responding" During Run Time in VBA Excel?
body: <p>I'm very new with VBA Excel and i only know the things as far as i need for this report formatting task.</p>
  
  <p>I'm almost done with my task but when i run the program and start the progress, eventhough it works successfully, GUI is not responding for a minute. I share my code here, is something wrong with it? Can you suggest me any best-practice? I don't want it to freeze because it will look bad to my manager.</p>
  
  <p>Just to make it clear, by "not responding" i mean it freezes on the screen and says "Not Responding" on it's windows frame and when i click on it, it gives a message like this:</p>
  
  <p><img src="https://i.stack.imgur.com/6glvX.png" alt="enter image description here"></p>
  
  <p>*ps: the sheet that i get records has 20997 rows and 7 columns and i make some records to another sheet on same file sized and 20997 lines 23 columns. And my GUI is very simple, it has nothing but a CommandButton that starts the progress.</p>
  
  <p>How can i fix this?</p>