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
|