Thank you for helping me.

After the execution of the code, I get below

thenos = Str(Num(i)) + Str(Num(j)) + Str(Num(k)) + Str(Num(l))
Str(Num(m)) + Str(Num(n))

How do I insert the numbers in the cells row after row? i.e
num(i)-num(n) individually

I would like to add another count of (ISEVEN) of thenos,how to go abou
it?

The results will be as below example

1 , 2 , 3 , 14 , 22 , 26 4-this 4 is the count of EVEN

Regards
Michae

--
Message posted from http://www.ExcelForum.com