code to Copy numbers 1 to 100 in the same column repeating 5 times

Hi , i am new to vba and right now struggling to get small codes correct.

I need to write a code which gives me numbers 1 to 100 in the same column with each number repeated 5 times before i move to the next number like
1
1
1
1
1
2
2
2
2
2
till 100 .

Request help .

Re: code to Copy numbers 1 to 100 in the same column repeating 5 times

sorry that was a double posting by me , i just joined the forum . Still waiting if someone can help me with this

Re: code to Copy numbers 1 to 100 in the same column repeating 5 times

this worked brilliantly . Thanks a lot jproffer. I spent like 2 hours trying to do it and this did it in 10 seconds . I am new to vba and very hopeful that wil speed up my learning with this forum. This is an excellent place .

Thanks everyone.