worksheets("formatline").Range("A30:AI30").Name :="FormatTempITC105"


"Billy B" wrote:

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?