Named Range in sheet created by Macro

I have a workbook in which I have set several macros. One of these macros creates a new worksheet. I need a named range on this new worksheet to select the records I want. When I am on the new worksheet, I can create and use the named range. However, the named range appears to be attached to the new worksheet, meaning that if the new worksheet is not yet present (created from the macro), once the new sheet is created, the named range does not really do anything.

I have to have this named range (called export -- it is to select the records I want to export to Access) in order to do the export correctly.

Any ideas here. It seemed to work before but I can't get it to work now.

Thanks for your response. Can you help me figure out a workaround? I have to have a named range to run the Import macro in Access. Yeah, I get it now, at least the reason why, because once the Converted sheet is deleted (via macro), the Named Range Reference is lost.

I may have to figure out a way to specify the actual worksheet in Access rather than the named range. Hmmmm

Thanks for the responses. I finally got this to work by attaching the macro to select the named range to the workbook rather than the worksheet. Duh.