Looping until an empty cell

[Ricardo9211]

Hello
I have a macro in which i am taking information from one cell and puting it in to a text box but need to repeat this process from B1 to C1 to D1 etc here is what I have so far

Please Login or Register  to view this content.

[se1429]

Hi,

Try this:

Please Login or Register  to view this content.

You may have to modify the line inside the loop. The way I see it now is that the last value will overwrite the previous one!

Regards.

[Ricardo9211]

Thank you very much