1) I need to store value from column A, B, C, F, H, L into an array, until in column A the last cell is blank.
2) loop the array
Note:
in column L i can hve a value #N/D
.xls is stored in c:\servizio\ with name TST.xls
STORE values in column into array
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: STORE values in column into array
You'll have to loop through the rows anyway, so you might as well do that instead of filling an array.
Best wishes,
Hans
Hans