thanks for the info xlbo. When you mentioned EOF/ BOF it got me thinking and below solved it:
If Not EOF(1) Then
y = 1
ReDim panelists(300)
Do While Not EOF(1) ' Loop until end of file.
Line Input #1, panelists(y) ' Add Mnemonic to array...
Here is my problem:
ReDim panelists(300)
y = 1
Do While Not EOF(1) ' Loop until end of file.
Line Input #1, panelists(y) ' Add Mnemonic to array
y = y + 1
Loop
If IsArray(panelists) Then
ReDim Preserve...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.