Friday, 31 August 2012

Macro To Auto Fill A Specified Number Of Times In Same Column



Macro To Auto Fill A Specified Number Of Times In Same Column

Sub FILL()
Dim A, B As Integer

A = InputBox("Enter No.of Times to Fill:")

For B = 1 To A - 1
Selection.Offset(B, 0) = Selection.Value

Next B
End Sub


 

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts