VBA/Macro

Hi,

Wondering if someone can help me.

I have a Userform where i have duplicated a certain row into 2.

I then used this text to try and come up with what i need.

Selection.Offset(1, 0).Columns(8).Value = (Columns(8).Value / Columns(6).Value) * Me.txtQuantity

So in my head the Offset is Selecting both the rows (my previous and duplicate). Then in Column 8 the value i would like to divide by Column 6 Value then i am multiplying then number by the number i put into the User form, and this number will be repersented in Column 8.

But it does not like this, any help?

regards