Refering to a cell reference based on a variable

[bd528]

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