No error but no result returned while performing a VBA Sorting Code

**seigna** · 05-06-2013, 08:16 PM

Hi,

I have the following problem with a code. I have created a sorting procedure in VBA. It is supposed to sort values and then return the value from the sorted array that corresponds to Int(n*a), where n=177 and a=0.05. The problem is that it returns no error and NO VALUE..

Would anyone be able o see where could be the problem? I attached my file in google docs! https://docs.google.com/file/d/0Bwjh...it?usp=sharing

Please Login or Register  to view this content.

**Norie** · 05-06-2013, 08:54 PM

The array ValeursActions is never filled with values.

Which sheet should it be taking the values from?

Which cell is Cells(i+1) supposed to refer to?

If I is 1 to 177, then that's going to refer to the cells in B1:FV1.

Also, without a worksheet reference it will refer to the worksheet the code is in, which is another reason to have the code in a standard module and to use a worksheet reference.

**Norie** · 05-06-2013, 09:03 PM

This doesn't error and puts values on 'Peformance des fonds'.

Don't know if they are the right values but they are values.

Please Login or Register  to view this content.

**seigna** · 05-07-2013, 02:56 AM

Thanks, ..yes, they are the right values

And I just saw I wasn't filling ValeursAction with anything either

No error but no result returned while performing a VBA Sorting Code

LinkBack

Thread Tools

Rate This Thread

Display

No error but no result returned while performing a VBA Sorting Code

Re: No error but no result returned while performing a VBA Sorting Code

Re: No error but no result returned while performing a VBA Sorting Code

Re: No error but no result returned while performing a VBA Sorting Code

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions