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

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts