Hi All,
After a while Googling, I can't seem to find exactly what I'm trying to do.
I have a cell with some Text (With Line breaks etc) I want to be able to Copy and Paste the Text into Multiple Rows/Cells.
If I go into the cell and copy the Text (Not the cell) and paste - it works - But I need it in VBA as its looping through 4500+ rows
For Example: Cell A1
How do I copy this cell/Text in VBA and paste into 4 rows, so it ends up like this:
Thanks in Advanced
After a while Googling, I can't seem to find exactly what I'm trying to do.
I have a cell with some Text (With Line breaks etc) I want to be able to Copy and Paste the Text into Multiple Rows/Cells.
If I go into the cell and copy the Text (Not the cell) and paste - it works - But I need it in VBA as its looping through 4500+ rows
For Example: Cell A1
This is the text With Line Breaks etc 001 Line 002 Row |
How do I copy this cell/Text in VBA and paste into 4 rows, so it ends up like this:
This is the text |
With Line Breaks etc |
001 Line |
002 Row |
Thanks in Advanced