I programmed many many years ago but am not familiar with VB. If you can point me to a starting point that would be great. Please see the screenshot below: Youll notice that row number 2 (cat/parrot) is divided. I would like to take the generated report and put in the macro and have my data split. How do I split a cell in Excel into two or more where they are divided horizontally. The data is generated output so I would prefer to not manually manipulate the data before splitting it. My data is currently around 500 lines but could go longer. I would like to repeat column A - L, and N-Q for each item from the split of the data in column M.
I have a similar situation to the previous post however instead of 3 columns of data my data goes from A - Q and my comma separated field is in 'M'. My question is around my particular need for this code. I have hundreds of lines of data that I need to split data in so I need to fix this error. , It says something about declaring Global Objects in the code. I found a reference to it on this message board but am not sure how to fix. 'Error -2147417848 (&H80010108): The object invoked has disconnected from its clients.' The issue is that the code appears to break after 40 lines of data, at the point where the data gets shifited over 1 column it takes the first 40 lines and blows up with the following error. Thanks for the post, this gives me a starting point.
