title: Copy and paste repeatedly a set of values one after the other for multiple times using Macro
body: <p>I have a set of strings lets say A, B, C, D, E, F, G, etc. in my 1st row in different cells. Now I want to copy and paste A 5 times beginning with row 1 which is followed by B 5 times and then C and so on. I know there is for loop involved in that but am unable to make my way through it.  I will be grateful if someone could help me on this.</p>