Split data into rows

[meabrams]

I need a macro that will split data into rows if more than one line exist in the row and when it runs into this it need to insert a new line before splitting it a part so not to write over info that is below it.

Sample.xlsx

Thank you for your help

[jindon]

Try

Please Login or Register  to view this content.

[meabrams]

I get compiling error on split

Wrong number of arguments or invalid property assignment

[jindon]

Working here and should work without problem.

[meabrams]

It works in there but in the real file I am still getting that error

[jindon]

If you are talking about the file other than the one you uploaded, no help.

[meabrams]

I know that this isn't probably going to help much but here a blanked ver of the file before it grabs the data from other files which might be part of the problem is how it grabs that data

Blank.xlsm

[jindon]

You are asking completely different question now.

What is your desired result then?

[meabrams]

the same as before I need to be able to split the data into rows but something in my file seems to be throwing the error when it comes to the SPLIT function

[jindon]

No, you need to show us EXACT desired result, otherwise wasting time...

[meabrams]

I copied in data from the sample.xlsx and tryed to run the macro for spliting and I still get the same error the macro is stored on test module.Blank.xlsm

[jindon]

Because you have a procedure named "Split", which should not be named like that, otherwise you can not use vb built-in function Split.

[meabrams]

Thank you I did not even see that

(I feel a little dumb right now LOL)

[jindon]

OK, I don't know if you named it so or you just copied that procedure from somewhere, just remember not to use vb reserved word for a procedure name to avoid any problem.

[meabrams]

It was me naming in an effort to try to break apart a huge macro. I slim it down and broke it apart so I could better follow it and I wasn't thinking straight when I named that one... I then I was hour 43 wake lol thank you for pointing it out to me and it is now fixed

[apo]

For posterity sake.. here's another one to try..

Please Login or Register  to view this content.