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....
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....