Can't autofill a formula to a variable last

Hi,

I'm new to excel macros and I'm trying to create a macro that will autofill a formula down to the last row with a value. The number of rows in this spreadsheet will consistly change, so I need the macro to accommodate the number of rows within the document without populating blank rows.

I've reviewed many forums and tried many things...such as

Selection.AutoFill Destination:=Range("C2:C337"), Type:=xlFillSeries

This still populates to C337 even if I delete rows. I need to autofill to however many rows are there depending on the spreadsheet.

I also tried...

Range("E2", Range("E2").End(xlDown)).Name = "typecolrange2"
Selection.AutoFill Destination:=typecolrange2, Type:=xlFillSeries

I'm still getting errors with the range not being correct.

Any help would be appreciated.

THank you!