title: VBA Selection.Copy copies a completely different range when running my code
body: <p>I have spent the day trying to understand what is going on with my excel.. I am running some code which worked fine before, I modified part of it early up (but which still works fine), and now a Selection.Copy later on in the code has stopped working. Here it is :</p>
  
  <pre><code> Range("AE3").Select
   Range(Selection, Selection.End(xlDown)).Select
   Selection.Copy
  </code></pre>
  
  <p>I used break points to find the problem. After the first two lines of code, it is the data in column AE which is selected. When I move on to the last line (Selection.Copy), it is not the data in AE which is selected but the columns AA and AB. I have tried literally everything I can think of to try and fix this but can't find anything.. </p>
  
  <p>If I run the code up to this point of the code and do the selection and copying manually, it also copies the wrong cells (it copies AA and AB like when it's done with vba)</p>
  
  <p>I would post screenshots of it but you can't put photos here it seems.</p>
  
  <p>Thanks for your help!</p>
  
  <p>Resolved: </p>
  
  <p>I went through the code step by step and noticed that previously in the code I copied the data from columns AA and AB to lower columns. To do so I had selected the columns and then copied them. I changed that so that I selected only the data in the columns and not the columns themselves and copied the data. This change has made my code work. I'm not sure why this was effecting the later Selection.Copy, but it was in some way. Thank you everyone for their help!</p>