Macro to Autofill column

[dmcclel]

I have set up a macro to help with a file I work on weekly. I get a new import each week and the # of lines in the file differ from week to week. I do not know how to set it up so it autofills my column (D) to the last cell with info in the previous column (C). The way I have it set up just autofills to the range in my original file. How do I set this up so it only autofills to the last full cell in column C.

COL A COL B COL C COL D
XXXX XXXX XXXX XXXX
XXXX XXXX XXXX
XXXX XXXX XXXX
XXXX XXXX XXXX
XXXX XXXX XXXX
XXXX

This is the code that I have. How can I fix this?

Selection.AutoFill Destination:=Range("D2:D395")
Range("D2:D395").Select

Thanks for any help!!

 

[Weaver]

try

range("D2",cells(rows.count,"C").end(xlup).offset(,1)).formular1c1=range("D2").formular1c1

 

[VoG]

Try

LR = Range("C" & Rows.Count).End(xlUp).Row
Range("D2").AutoFill Destination:=Range("D2:D" & LR)

 

[dmcclel]

try

range("D2",cells(rows.count,"C").end(xlup).offset(,1)).formular1c1=range("D2").formular1c1

I tried this and it still fills to the last ROW with information. There is alot of junk info in column A and B and the rest of my macro will delete those columns if I can get the auto fill to stop at the last full cell in Column C

 

[Weaver]

try it this way then:

range("D2",range("C2").end(xldown).offset(,1)).formular1c1=range("D2").formular1c1