Print value in each cell in range from userofrm

[cajand]

Hello,

From a userform I execute a macro that copies range r to the lastrow in range 2.
However, I want to add the value form a textbox (txtNamn) in the userform to
every row that gets pasted in range r2, I want the values in column D.

I suppose I have to use me.txtNamn to get the value, but how do I got about
adding it to every row?

Thanks in advance

Please Login or Register  to view this content.

[Debraj Roy]

Try something like this..

Please Login or Register  to view this content.

BTW, avoid using ActiveSheet as much as possible..