STORE values in column into array

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

STORE values in column into array

Post by sal21 »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: STORE values in column into array

Post by HansV »

You'll have to loop through the rows anyway, so you might as well do that instead of filling an array.
Best wishes,
Hans