Hi everyone,
I am a beginner in Excel VBA and got stuck in a part of my code.
What I want to do is to transform the data from
<tbody>
</tbody>In words, I just want to copy the element in the first row to the first column, until the end of the data xxx.
The length of the data xxx varies, depending on the context.
My code so far is
Selection.Copy
ActiveCell.Offset(1, -1).Range("A1:A100").Select
ActiveSheet.Paste
But I want to adjust the range to paste to "the end of the rows in the next column", not "A100".
What should I do? Any helps will be much appreciated!
yn
I am a beginner in Excel VBA and got stuck in a part of my code.
What I want to do is to transform the data from
[Before Macro] title xxx xxx xxx xxx [After Macro] title title xxx title xxx title xxx title xxx | ||
<tbody>
</tbody>
The length of the data xxx varies, depending on the context.
My code so far is
Selection.Copy
ActiveCell.Offset(1, -1).Range("A1:A100").Select
ActiveSheet.Paste
But I want to adjust the range to paste to "the end of the rows in the next column", not "A100".
What should I do? Any helps will be much appreciated!
yn