Need to create named range but with variable range

[bhodge10]

Hello, I have a worksheet that imports data into a sheet on my main file. I have the following code to create the named range and it works fine. However the "Accounts by Contract Rep file that I import may expand or decrease in the number of rows needed so I would like to be able to make the last row (regardless of what row #) that contains data the end of the range. How can I do this? Thanks.

        Range("A6:A" & Cells(Rows.Count, "C").End(xlUp).Row).Select
        ActiveWorkbook.Names.Add Name:="assignedreps", RefersToR1C1:= _
                                 "='Accounts by Contract Rep'!R6C1:R1100C1"

[buckhunt122]

If you could build a generic worksheet/s emphasizing what you would like to do (with non sensitive data) you will get a very timely response. The people on this forum are great!

[davegugg]

What is that first line supposed to do?

You could use this instead:

Range("A6:A" & Cells(Rows.Count, "C").End(xlUp).Row).Select
        ActiveWorkbook.Names.Add Name:="assignedreps", RefersToR1C1:= _
                                 "='Accounts by Contract Rep'!R6C1:R" & Cells(Rows.Count, "A").End(xlUp).Row & "C1"

[bhodge10]

Thanks Davegugg!! I guess my first line was the attempt to select the range. But I see now that the it isn't needed. Your tweak works perfectly, thank you!!!