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:

    x.Cut Cells(x1.Row, 1)
  • The code that I provided worked perfectly on some sample data. I don't see why it wouldn't work for you, unless there were gaps in the data.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!