CSng <Subscript out of range> - Completely Stumped

[skania]

The program I'm writing is going to parse a file and extract certain data and then sync 2 files (attention and heart rate).

here is the string causing the problem:

Look 1 (Center) -- Start Time: 0.2 sec, End Time: 2.6, Duration: 2.4 sec

Yes, the spaces in the front are standard, and there are 15, I used word and displayed hidden characters.

/edit - there ARE 15 leading spaces, it doesn't show it though...


Here is the code causing the problem:

Please Login or Register  to view this content.

I need to extract the "0.2" from the string, and place it into an array, however, it tosses an error, and while debugging, siStartLk(iTrialctr, iLkctr) shows siStartLk(iTrialctr, iLkctr) = <Subscript out of range>. Where iTrialctr and iLkctr are both 1 (first trial, first look, so it essentially gets caught instantly). I've checked and counted the indexes correctly, I THINK.
When the program breaks these are the following values:
iStartLoc = 38 (index of "S") (the + 12 gives 50, '0' in '0.2')
iTimeLen = 3 (which it should be, '0.2')
iCommaALoc = 57 (-5, is '2' in '0.2'

Am I missing something?

[tehneXus]

try

Please Login or Register  to view this content.

[skania]

I'm still gettting

Please Login or Register  to view this content.

[tehneXus]

As the conversion of the 0,2 works fine for me when I assign it to a variable my next guess would be that the array is too small.

You are starting your arrays with the index 1 but iTrialctr = 0 ^^

Regards

[skania]

iTrialctr starts at 0, but is incremented by 1 in the first if statement.
While debugging, and hovering over the variable - it says the value of both variables in siStartLk() are 1,1.
:/

[tehneXus]

Mhh, I can do that without a problem, please insert "Option Explicit" at the top of the code module and click "Debug" -> "Compile VBA Peoject". Then you are forced to declare all your variables but I guess you are using an array which wasnt declared at all

[skania]

The code is much, much longer. This was only a snippet of the code, I do have Option Explicit - always. So that the macro doesn't slow down .

Are you using 2010? That's the version of Excel I use at work.

[tehneXus]

I am using 2013.

1. Try to assign the 0,2 to a variable instead of the array

2. make sure you are using the correct array, "iStartLk" is re-sized at the beginning of the snipped but "siStartLk" is used in the problematic line

3. debug the code (F8) and check the size of the array and the index variables in the locals window

cannot say any more as it works fine for me in 2013.

Regards

[skania]

I've added to the code:

Please Login or Register  to view this content.

and debugvar holds the correct value, and the same problem error '9' :/
Anyone have any idea?

I must have skipped over suggestion 2. After working on posting a book to StackOverflow, I realized the arrays weren't the same. Thanks tehneXus