Fill Down Problem

[DrDave6]

Hello,

I'm trying to copy some rows down, based on cell values, and this approach was recommended. However, I'm getting a compile error -problem with the last ")"

For context, StartRow = 16, and NumberToCopy = 826. Therefore, I'm trying to copy row 16 down to row 826.

Can anyone see the problem here?

sub Answer()
Rows(Range("StartRow").Value).Resize(Range("NumberToCopy").value-range("StartRow").value)+1).FillDown
End Sub

Thank you for your help....

 

[FormR]

Hi, try:

Rows(Range("Startrow").Value & ":" & Range("NumberToCopy").Value).FillDown

 

[DrDave6]

Worked Perfectly! Thank you.