confusion123
Active Member
- Joined
- Jul 27, 2014
- Messages
- 400
I have 3 columns of data.
would return all three columns.
but I only want the middle column.
Is there a quick way of doing that, instead of creating another array and looping?
Thanks
EDIT SORTED:
Code:
MyArray() = Cells(1,1)
would return all three columns.
but I only want the middle column.
Is there a quick way of doing that, instead of creating another array and looping?
Thanks
EDIT SORTED:
Code:
Application.WorksheetFunction.Index(Myarray, 0, 2)
Last edited: