Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error '1004'
Why does setting the RefersTo value cause a run-time error 1004 ?
Sub Macro_Change_Function() ' ' Macro_Change_Function Macro ' ' If Sheet2.CheckBoxes("Check Box 23").Value = False Then Sheet2.CheckBoxes("Check Box 23").Value = True Else Sheet2.CheckBoxes("Check Box 23").Value = True End If z = Sheets("Settings").Range("XLQ_Functions") x = GetRefersTo("Fill_Formula") a = SEARCHFORMULA(z, x) b = ("xlqh") & Sheets("Settings").Range("Data_Type") y = Application.Substitute(x, a, b) ActiveWorkbook.Names("Fill_Formula").RefersTo = y End Sub - Ronald K. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error '1004'
kittronald explained :
Why does setting the RefersTo value cause a run-time error 1004 ? Sub Macro_Change_Function() ' ' Macro_Change_Function Macro ' ' If Sheet2.CheckBoxes("Check Box 23").Value = False Then Sheet2.CheckBoxes("Check Box 23").Value = True Else Sheet2.CheckBoxes("Check Box 23").Value = True End If z = Sheets("Settings").Range("XLQ_Functions") x = GetRefersTo("Fill_Formula") a = SEARCHFORMULA(z, x) b = ("xlqh") & Sheets("Settings").Range("Data_Type") y = Application.Substitute(x, a, b) ActiveWorkbook.Names("Fill_Formula").RefersTo = y End Sub - Ronald K. Debug.Print y to see what it is. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error '1004'
Garry,
Just so everyone knows ... there's a 255 character limit for a name's Refers to: value. Of course, ... I already knew that. 8o - Ronald K. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error '1004'
on 10/11/2011, kittronald supposed :
Garry, Just so everyone knows ... there's a 255 character limit for a name's Refers to: value. Of course, ... I already knew that. 8o - Ronald K. Yes, I know that! I've never tried (via code) to enter anything longer so are you saying the length exceeded the limit and so the error? -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error '1004'
Garry,
That was the problem. - Ronald K. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Error 1004 opening workbook 1004 | Excel Programming | |||
Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004 | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |