I know how to make a dynamic named range for a single sheet. I can't find any information on how to extend the named range to the last sheet in the workbook. I am importing a delimited text file into Excel, and the size varies. I am using vba to automatically add sheets when needed. That causes me to have a fluctuating amount of sheets. Is there a formula for a dynamic named range that would go to the last used cell in the last sheet without specifying the sheet name? Is it even possible to have a dynamic named range that extends into another sheet? Thanks for any help you offer.