Assign sheet value to array... and redim the array size

Hi, I tried to get put my excel file value at column A to an array. But i keep on get the error msg of "systax error" .. and i have no idea why it is so... Please advise on my mistake...


Other than tat, is there any other way to get the total row number in stead of running a do loop as below? And i wish to assign the value to array directly while retrieving the row number as i commented in the do Loop... is that possible?

Please Login or Register  to view this content.

Thank u