Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating named range in VBA problem
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating named range in VBA problem
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating named range in VBA problem
The formula you gave me did not work. After careful study I found out why
neither of ours worked: There needs to be an = in the named range: worksheets("formatline").Range("A30:AI30").Name :="=FormatTempITC105" "Patrick Molloy" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating named range in VBA problem
my error - qa typo
I wrote worksheets("formatline").Range("A30:AI30").Name :="FormatTempITC105" instead of worksheets("formatline").Range("A30:AI30").Name ="FormatTempITC105" "Billy B" wrote: The formula you gave me did not work. After careful study I found out why neither of ours worked: There needs to be an = in the named range: worksheets("formatline").Range("A30:AI30").Name :="=FormatTempITC105" "Patrick Molloy" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem creating a named range | Excel Programming | |||
Problem with creating a named range | Excel Programming | |||
Creating a named range | Excel Programming | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Creating a Named Range using VB | Excel Programming |