I'm trying to do an autofill on a dynamic range of cells, and I'm having some trouble. Here is what I have so far:
Code:
Range("CR2:DC2").Select
i = Selection.End(xlDown).Row
Intersect(Range("CR:DC"), Rows(i)).Select
LastRow = ActiveSheet.Range("A1").End(xlDown).Row
Selection.Autofill Destination:=Range( ? & LastRow)
I'm not sure what to put as my starting range in the autofill. The starting row value is stored in "i", just not the range of cells that I want to autofill. I tried putting that intersect statement in there, but it gave me a "type mismatch" error. Does anyone know what to do? Thanks!