Run-time error '1004': Cut method of Range class failed

  • Hi Everyone,


    I'm using Excel 2016 and I can't seem to get my code to work.


    Just for fun I'm trying to create a script that turns data stored in multiple columns to be moved to a single column.


    ie data in cells A1:AE2000 to all end up under column A.


    I'm using the cut method but it doesn't seem to work.


    Any help would be greatly appreciated :)


    Here's the code I've got:


  • Try it this way


  • Thanks Roy for the suggestion. I was able to make the code work using some of what you suggested.


    This was an interesting exercise. I still don't understand why it didn't work using the original code.


    In any case I modified this snippet of my code and it worked:


    Code
    1. x.Cut Cells(x1.Row, 1)