No, he quoted mine, so he must have seen it.

It's nothing to do with jeopardy, but it is wasting my time if I see a
response to my post as I tend to read it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"SteveM" wrote in message
...
On Dec 9, 9:09 am, "Bob Phillips" wrote:
Why do you always reply to someone else's post instead of the original
post,
especially when you then just say the same thing?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Joel" wrote in message

...

Sub test()r

myarray = Array(1, 2, 3, 4)
total = WorksheetFunction.Sum(myarray)
End Sub

"Bob Phillips" wrote:

Yeah, no problem, such as

Application.SUM(array)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"hmm" wrote in message
...
I know I can use Excel worksheet functions in VB. My question is
when
one
of
the parameters of a function is an array. Can I used an array
defined
in
VB
code (instead of the usual worksheet-range input) as the argument
for
this
function? Thanks.

Before a fence war starts, I've noticed that responses are not posted
immediately. So I'm assuming two guys can submit the same idea before
each has seen the other's posted. Now I also get the feeling that we
have an understated Jeopardy thing going on here in being first to
respond. Maybe if you guys got buzzers....:)

SteveM