Using RANK function in VBA code

[aloha31]

I'm getting an error stating 'Unable to get Rank function...etc'

Is my syntax incorrect? My variable 'howmany' stores a value of 146, so it shouldn't be resulting from that. I'm stumped here.

Please Login or Register  to view this content.

[JieJenn]

Can you post your file?

[aloha31]

Book2.xlsx Here is the worksheet I am working with (sans VBA code since the full file is far too big to post)

[JieJenn]

your vba works fine for me. Maybe because you didn't declare your variables?

Please Login or Register  to view this content.

[aloha31]

No, that didn't fix it unfortunately. Is there a different syntax in which i can write this?