Using Loop Macros with RefEdit controll in userform

Hi Guys

im trying to use a userform with 2 refedit controlls on it, one is input ant one is output.
I have what i need to do down ok when only using one cell per refedit

but here is where i am struggling

I want to make it so if i select multiple cells it will do the process for each cell and output accordingly.

the way i am doing it at the miniute is

Please Login or Register  to view this content.

but i dont know how to reference to a cell in the second range (it just uses all of them at once)

the only way i can think of doing this is to use a collection but this caould be a bit more long winded that i would like.

Please Login or Register  to view this content.

But simpler is:

Please Login or Register  to view this content.

So simple

thanks!
Ill let you know how it goes

what if my range is more than 1 coulmn and 1 row
does it go down first or accross??

I added a simpler solution after the first one.

the first one works fine for me
i am not actualy copying the cells over there are other things i am doing so i think that the first solution is more practical =D

Thanks Buddy
(rep added)