Refering to a cell reference based on a variable

Hi,

I have defined Numrows as an integer.

I want to use the following code :-

Selection.AutoFill Destination:=Range("M6:M410")

But rather than M410, I want the code to copy down to "numrows"

How can I code this?

Thanks in advance

It's not clear what you're "filling" - formula/value etc... it's generally quicker to apply to a contiguous range using the below approach as opposed to AutoFill.

Range("M6:M" & numrows).Formula = Selection(1).Formula

If we assume numrows is 10 then M6:M10 will assume the formula of the first cell in the selection.

If numrows is meant to represent the size of the vector rather than the literal end row number (implied by naming convention - ie number of rows) then you would use Resize

Range("M6").Resize(numrows).Formula = Selection(1).Formula

this would apply the formula to M6:M15 (10x1)

If you're still having problems post a sample.

(we assume the sheet is unprotected etc...)

Sorry, just looked at this...

Sub Example()
Range(Cells(5,"A"),Cells(Rows.Count,"A").End(xlUp)).Offset(,12).Formula = "=K5-L5"
End Sub