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.
Bookmarks