|Your explanation is still confusing.|
In your original post you said:
"i want the row to repeat (1 -10) rows depending on the number."
In your next response you said:
Column A - duplicate 1 times
Column B - duplicate 2 times
What is that you want to repeat/duplicate - rows or columns?
In addition, please click on the following line and read the instructions on how to post example data in this forum. When posting data, it helps to include Column letters and Row numbers so that we know what we are working with.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.