Need to create named range but with variable range

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.

Please Login or Register  to view this content.

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!

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!!!