Prev: Select One
Next: error handling in VBA
From: Robert Crandal on 8 Mar 2010 16:00
Chip,

Cool, I just have one question for you. I looked all over the
VBA documention and I don't see anything to indicate that
the ".Transpose" method is a member of the Application
object.

Will the "Transpose" function still work okay even though it
doesn't show up in the function list after I type "Application."???

As always, thanks for your great advice!


"Chip Pearson" <chip(a)cpearson.com> wrote in message
news:eto9p59jmlk3qg5h24ku3vrhgrgq7a93ge(a)4ax.com...
>
> .List = Application.Transpose(Arr)
>

From: Dave Peterson on 8 Mar 2010 16:50
Before xl97 (I think), the way to access the worksheet functions from code was
to use:

Application.functionnamehere

xl97 introduced this kind of thing:
application.worksheetfunction.functionnamehere
or
worksheetfunction.functionnamehere

For the most part, all three are interchangeable.

But not always!

Two examples where they are not are with:

application.vlookup() and application.match
and
application.worksheetfunction.vlookup() and
application.worksheetfunction.match()

These behave different if there is no match.

=======
And because Chip is old <vbg> and grew up with excel, he continues to use
application.functionnamehere. About the only thing he loses is the VBE's
intellisense (but that's not useful for these anyway!).



Robert Crandal wrote:
>
> Chip,
>
> Cool, I just have one question for you. I looked all over the
> VBA documention and I don't see anything to indicate that
> the ".Transpose" method is a member of the Application
> object.
>
> Will the "Transpose" function still work okay even though it
> doesn't show up in the function list after I type "Application."???
>
> As always, thanks for your great advice!
>
> "Chip Pearson" <chip(a)cpearson.com> wrote in message
> news:eto9p59jmlk3qg5h24ku3vrhgrgq7a93ge(a)4ax.com...
> >
> > .List = Application.Transpose(Arr)
> >

--

Dave Peterson
 | 
Pages: 1
Prev: Select One
Next: error handling in VBA