B
Billy B
I have created the following line of code in the Workbook_Open event of a
workbook:
Application.Names.Add Name:="FormatTempITC105",
RefersTo:="FormatLine!$A$30:$IA$30"
After I open the workbook, if I check for the named range in the
Insert/Names/Defines, the name exists. If I look in the Name Box, it is not
listed.
The problem I have is that, if the named range is being created by the
Workbook_Open event, I get an error in the worksheet code using the name
range above. If I don't put the code in the Workbook_Open and create the
named range from the Insert/Name/Define, the worksheet code runs fine.
Is there something I am missing when creating the named range in the
Workbook_Open event code?
workbook:
Application.Names.Add Name:="FormatTempITC105",
RefersTo:="FormatLine!$A$30:$IA$30"
After I open the workbook, if I check for the named range in the
Insert/Names/Defines, the name exists. If I look in the Name Box, it is not
listed.
The problem I have is that, if the named range is being created by the
Workbook_Open event, I get an error in the worksheet code using the name
range above. If I don't put the code in the Workbook_Open and create the
named range from the Insert/Name/Define, the worksheet code runs fine.
Is there something I am missing when creating the named range in the
Workbook_Open event code?