DataBlake
Well-known Member
- Joined
- Jan 26, 2015
- Messages
- 781
- Office Version
- 2016
- Platform
- Windows
Code:
Sub aanewWPcode()
Dim ary As Variant
Dim i As Long
With ActiveSheet
ary = .Range("A1").CurrentRegion.Value2
End With
End Sub
So i have this macro that will assign an entire sheet as an array
I'm trying to copy the entire 2nd column to the 1st column so
Blank | Part Number |
123 | |
456 | |
789 |
<tbody>
</tbody>
becomes
Blank | Part Number |
123 | 123 |
456 | 456 |
789 | 789 |
<tbody>
</tbody>
i don't want to use i = 2 to ubound
i want to write this using the range.value = ary method, but i'm not sure how to write that line.