XIRR range question

R

Ron Rosenfeld

However, note that v must actually contain a value. It is not sufficient to
merely declare the object type of v. For instance:

I agree that it is NOT sufficient to merely declare the object type. However,
I don't believe it is strictly true that the object must actually contain a
value. There are objects that do not even support the Value property.



--ron
 
J

Joe User

Ron Rosenfeld said:
I agree that it is NOT sufficient to merely declare the object type.
However, I don't believe it is strictly true that the object must
actually contain a value. There are objects that do not even support
the Value property.

Well, we can quibble over what I meant by the word "value". It certainly is
not limited to mean that there is a Value property per se in the object.


----- original message -----
 
R

Ron Rosenfeld

Well, we can quibble over what I meant by the word "value". It certainly is
not limited to mean that there is a Value property per se in the object.

OK, I was using in that sense, since that is how I determine the Value of a VB
object. When you wrote that, my first attempt at verifying was to look for the
Value of a regular expression object. (e.g. re.value)

If you want to use it to mean something else, that's OK with me.

--ron
 
J

Joe User

Ron Rosenfeld said:
If you want to use it to mean something else, that's OK with me.

Thank you. I hope the next time that I mention the "value" of a Double
variable v, you do not chide me because v.Value does not work :) :).


----- original message -----
 
R

Ron Rosenfeld

Thank you. I hope the next time that I mention the "value" of a Double
variable v, you do not chide me because v.Value does not work :) :).

Of course not. But (more definitions now :))) I don't think I would consider
a Double to be an Object, in the sense we've been discussing.

As said:
"Note TypeOf cannot be used with hard data types such as
Long, Integer, and so forth other than Object."

--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR Help 0
XIRR - Function Missing 1
XIRR and Non Contiguous Cells 2
XIRR question 5
XIRR #NAME? error - Toolpak IS installed 1
XIRR Help 3
Help with Code 3
Why Doesn't XIRR work? 2

Top