macro_user
Board Regular
- Joined
- Mar 9, 2009
- Messages
- 101
hi...
i have a single column of values which i need to take into an array and then, i need to process the array... i have the code if its multiple cells.
so, this moves values from columns C and D from the 2nd row tilll the last row in the array ref_arr..
but wat if its just a column...?
i tried this but it isn't working...
Kindly help me out on this...
i have a single column of values which i need to take into an array and then, i need to process the array... i have the code if its multiple cells.
Code:
lastrow = range("C65536").end(xlUp).row
ref_arr = Sheets("sheet1").range("C" & 2, "D" & lastrow).value
but wat if its just a column...?
i tried this but it isn't working...
Code:
ref_arr = Sheets("sheet1").range("C4" & lastrow).value