Very new to Macros and VBA.
I have managed to find my total rows in my sheet, and I have that number stored in a variable.
I need help with using this variable to copy a specific range from one column of my sheet to another column in the same sheet.
here is what I have so far.
Dim MyRow As Long
MyRow = Cells(Rows.Count, 1).End(xlUp).Row
The MyRow variable contains the value 64842
So here is where I need some help.
For example I would like to use the variable to help me copy a specific range from one column to another column.
so let's say I want to copy row 2 to 100 from column a and copy them into column AA2
or I want to copy all of the rows in column A (minus A1, because I have headings) to Column Z row 2
How can I use a variable to copy specific rows?
Thanks for the help,
Rocco
I have managed to find my total rows in my sheet, and I have that number stored in a variable.
I need help with using this variable to copy a specific range from one column of my sheet to another column in the same sheet.
here is what I have so far.
Dim MyRow As Long
MyRow = Cells(Rows.Count, 1).End(xlUp).Row
The MyRow variable contains the value 64842
So here is where I need some help.
For example I would like to use the variable to help me copy a specific range from one column to another column.
so let's say I want to copy row 2 to 100 from column a and copy them into column AA2
or I want to copy all of the rows in column A (minus A1, because I have headings) to Column Z row 2
How can I use a variable to copy specific rows?
Thanks for the help,
Rocco