Sorting, even-odd

[dasnoob]

Hi!

I'd have to do ha macro which collects 10 numbers from the user and then sort the numbers (in the marked cells) in a way that all the even numbers comes first, and the odd ones after.

Could somebody please help me?

[Chabu]

hey dasnoob,

you really have to try things first :-)
use the help I gave you in your previous question. Put the even numbers in one array, the uneven ones in another (use check on remainder of mod 2 ( search for "mod" in the help )) to put the number in one of both arrays.
Then sort the arrays.

Try it out and post your code if you get stuck

Greetings

[GTO]

Cross-posted: http://www.thecodecage.com/forumz/members-excel-vba-programming/208993-sort-even-odd.html

[mikerickson]

dasnoob,
Welcome to VBA Express.

Would you please read this link. How to Cross Post (http://www.excelguru.ca/node/7)

It explains why we, like almost every other Excel forum, require that if you cross-post (post the same question in two forums) that you provide a link to the other forum.

Thanks.