AutoFill 1004 runtime Error - Create a If error skip?

[Grimm127]

Hi All,<o></o>
<o></o>
I am using this autofill code for my macro.<o></o>
<o> </o>
Sheets("Data").Select<o></o>
'This counts the # of Rows in the Coulmn A<o></o>
IngoMaxRo = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row<o></o>
<o> </o><o> </o>
Range("R6:T6").Select<o></o>
Selection.AutoFill Destination:=Range("R6:T" & IngoMaxRo - 4)

The problem is that there are times when the IngoMaxRo will be equal to the source row. Hence creating a 1004 run time error.

I would like to know how to create an if error skip autofill if source row = autofill row. If sourcerow <> autofill row then autofill

Thanks in Advance!

 

[Joe4]

Maybe something like:

[COLOR=#000000][FONT=Times New Roman]If[/FONT][/COLOR] ([COLOR=#000000][FONT=Times New Roman]IngoMaxRo - 4)>6 Then
[/FONT][/COLOR][COLOR=#000000][FONT=Times New Roman]    Selection.AutoFill Destination:=Range("R6:T" & IngoMaxRo - 4)
End If[/FONT][/COLOR]

 

[Grimm127]

Hi!

That was exactly it! Works Perfectly now!

Thank you!