Autofill with a variable range

Hey,
I have a formula in cell C1, and I want to drag it down to the end of the used range of the column with vba. I drag it down in vba, but it goes down far below the range I use, so I want to specify that it stops dragging down once it hits the last row. I even have a way to find that last row, as you can see below. The trouble I'm having is the syntax for the Destination -- I don't know how to denote that the destination range should be from C,1 to c, mylastrow. Any ideas?

Please Login or Register  to view this content.

Please Login or Register  to view this content.