Repeating Macro

**jackuspi2010** · 03-27-2013, 11:54 AM

Hi

I have the following macro

PHP Code:


Sub Macro2()

'

' Macro2 Macro

'



'

    Range("B1:D1").Select

    Selection.AutoFill Destination:=Range("B1:D2"), Type:=xlFillDefault

    Range("B1:D2").Select

End Sub

I need something on the end of this macro to make it repeat itself all the way down column B for a set number of rows. Im sure this is simple but cant seem to get it.

**HaHoBe** · 03-27-2013, 12:27 PM

Hi, jackuspi2010,

assuming that in Column A are values which deztermine the way down to copy the data:

Sub Macro2re()
'
' Macro2 Macro
'

'
    Range("B1:D1").AutoFill Destination:=Range("B1:D" & Cells(Rows.Count, "A").End(xlUp).Row), Type:=xlFillDefault
End Sub

Ciao,
Holger