john3j
05-20-2015, 10:49 AM
Cell A5 contains the following multiline text:
This
Is
A
Test
I am trying to figure out how to get the following:
Range("A5").Value = "This"
Range("A6").Value = "Is"
Range("A7").Value = "A"
Range("A8").Value = "Test"
Is there a way to select the contents of a multi line cell and paste it so that each line is in a new row?
This
Is
A
Test
I am trying to figure out how to get the following:
Range("A5").Value = "This"
Range("A6").Value = "Is"
Range("A7").Value = "A"
Range("A8").Value = "Test"
Is there a way to select the contents of a multi line cell and paste it so that each line is in a new row?