Subscript out of range error in a Sub procedure with ranges and arrays

**seigna** · 05-05-2013, 01:31 PM

I have written the following VBA Code, and at one point I place values from a Range (CoursAction) into an array(ValeursAction). Later on I use the values in the array to obtain a threshold value (Var). However, I get a "Subscript out of range" error though I think I have defined everything.

Or is it ValeursAction() As Variant that is incorrect? It is supposed to be an array... Or should I Re-dimension it? I am sorting it with Call Tri1(ValeursAction).

Please Login or Register  to view this content.

**rylo** · 05-05-2013, 08:12 PM

Hi

Your sub must be taking forever to run.

I made a change as below

Please Login or Register  to view this content.

to cut down the size of the range being actioned.

I found the error on the line

Please Login or Register  to view this content.

In your example file there is no sheet Performance des fonds. Is that a problem with the example file, or is that the real error?

rylo

**seigna** · 05-06-2013, 04:57 AM

no, that's just me who didn't change it. It's supposed to be the first sheet. Performance. In the original file there's no such mistake and still it doesn't read well..

**rylo** · 05-06-2013, 06:41 PM

Hi

OK, changed that and found it is failing on the next line

Please Login or Register  to view this content.

Looking at the values in the variables:
NB: 14
alpha: 0.05
When you multiply those, you get 0.7 and the INT then gives you 0. As this isn't a valid index for the array valeursaction (lbound is 1) then you are getting the error.

Does this help in knowing what to do to correct your code?

rylo

**seigna** · 05-06-2013, 06:43 PM

Isn't Int supposed to round UP? to 1?

**rylo** · 05-06-2013, 08:53 PM

Hi

No, INT just takes the integer component of the number (for positive numbers). From the help file

Rounds a number down to the nearest integer

rylo

Subscript out of range error in a Sub procedure with ranges and arrays

LinkBack

Thread Tools

Rate This Thread

Display

Subscript out of range error in a Sub procedure with ranges and arrays

Re: Subscript out of range error in a Sub procedure with ranges and arrays

Re: Subscript out of range error in a Sub procedure with ranges and arrays

Re: Subscript out of range error in a Sub procedure with ranges and arrays

Re: Subscript out of range error in a Sub procedure with ranges and arrays

Re: Subscript out of range error in a Sub procedure with ranges and arrays

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions