Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
I have the following code:
db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
hi
try set db = Range("currentdb") you set objects and a range is an object. values are just equals(=) regards FSt1 "ranswrt" wrote: I have the following code: db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
I have
dim db as string I am trying to get the string from the cell named 'currentdb'. I have used this same code in other procedures and it has worked fine. "FSt1" wrote: hi try set db = Range("currentdb") you set objects and a range is an object. values are just equals(=) regards FSt1 "ranswrt" wrote: I have the following code: db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
Check your spelling of that range name.
And check to make sure that the sheet being looked at actually has a range named currentdb. ranswrt wrote: I have dim db as string I am trying to get the string from the cell named 'currentdb'. I have used this same code in other procedures and it has worked fine. "FSt1" wrote: hi try set db = Range("currentdb") you set objects and a range is an object. values are just equals(=) regards FSt1 "ranswrt" wrote: I have the following code: db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
hi
a range is an object. a string is a value. i am confused now!?!?!?! if a string then...... dim db as string db = currentdb.value else dim db as range set db = range("currentdb") a string is somthing like "i am a string" a range is someting like A1:R20 are we on the same page?!?!?!? regards FSt1 "ranswrt" wrote: I have dim db as string I am trying to get the string from the cell named 'currentdb'. I have used this same code in other procedures and it has worked fine. "FSt1" wrote: hi try set db = Range("currentdb") you set objects and a range is an object. values are just equals(=) regards FSt1 "ranswrt" wrote: I have the following code: db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
hi dave,
thanks for your input. but did i miss someting about objects and values please correct me if i'm wrong. regards FSt1 "Dave Peterson" wrote: Check your spelling of that range name. And check to make sure that the sheet being looked at actually has a range named currentdb. ranswrt wrote: I have dim db as string I am trying to get the string from the cell named 'currentdb'. I have used this same code in other procedures and it has worked fine. "FSt1" wrote: hi try set db = Range("currentdb") you set objects and a range is an object. values are just equals(=) regards FSt1 "ranswrt" wrote: I have the following code: db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
The OP added this detail:
dim db as string in the followup post. So that means that: db = Range("currentdb") is relying on the default property of the range (.value). FSt1 wrote: hi dave, thanks for your input. but did i miss someting about objects and values please correct me if i'm wrong. regards FSt1 "Dave Peterson" wrote: Check your spelling of that range name. And check to make sure that the sheet being looked at actually has a range named currentdb. ranswrt wrote: I have dim db as string I am trying to get the string from the cell named 'currentdb'. I have used this same code in other procedures and it has worked fine. "FSt1" wrote: hi try set db = Range("currentdb") you set objects and a range is an object. values are just equals(=) regards FSt1 "ranswrt" wrote: I have the following code: db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
hi
i was unaware of a default value property. i thought that this had to be specified. after testing, you're rignt thanks for correcting me. i learned something. disregards all of my posts. regards FSt1 "Dave Peterson" wrote: The OP added this detail: dim db as string in the followup post. So that means that: db = Range("currentdb") is relying on the default property of the range (.value). FSt1 wrote: hi dave, thanks for your input. but did i miss someting about objects and values please correct me if i'm wrong. regards FSt1 "Dave Peterson" wrote: Check your spelling of that range name. And check to make sure that the sheet being looked at actually has a range named currentdb. ranswrt wrote: I have dim db as string I am trying to get the string from the cell named 'currentdb'. I have used this same code in other procedures and it has worked fine. "FSt1" wrote: hi try set db = Range("currentdb") you set objects and a range is an object. values are just equals(=) regards FSt1 "ranswrt" wrote: I have the following code: db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
error message
I think it's a good idea to specify the property that you want. I like it
because it makes the code much more self-documenting. FSt1 wrote: hi i was unaware of a default value property. i thought that this had to be specified. after testing, you're rignt thanks for correcting me. i learned something. disregards all of my posts. regards FSt1 "Dave Peterson" wrote: The OP added this detail: dim db as string in the followup post. So that means that: db = Range("currentdb") is relying on the default property of the range (.value). FSt1 wrote: hi dave, thanks for your input. but did i miss someting about objects and values please correct me if i'm wrong. regards FSt1 "Dave Peterson" wrote: Check your spelling of that range name. And check to make sure that the sheet being looked at actually has a range named currentdb. ranswrt wrote: I have dim db as string I am trying to get the string from the cell named 'currentdb'. I have used this same code in other procedures and it has worked fine. "FSt1" wrote: hi try set db = Range("currentdb") you set objects and a range is an object. values are just equals(=) regards FSt1 "ranswrt" wrote: I have the following code: db = Range("currentdb") I have used this code before in other procedures and it has worked. When I use in a userform_Terminate I get the error method 'Range' of Object'_Global' failed. 'currentdb' is a named cell on a worksheet. Why won't this work? Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
e-mail - error message Run-time error 429 | Excel Programming | |||
replace VBA run-time error message with custom message | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |