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
For Each Cell In Range(RefEdit1)
Range(RefEdit2).Value = Cell
Next
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.
Bookmarks