short cut to application.worksheetfunction.XYZ

[electricpete]

I notice a lot of people use statements like:
application.worksheetfunction.roundup( , )
application.worksheetfunction.max( , )
application.worksheetfunction.pi()

These type statements can be written a little faster using:
application.roundup( , )
application.max( , )
application.pi()

One difference is that you won't see the list of values from which to pick the function. But still gives more compact code.

What is the underlying object structure that allows two different ways to get to these functions? Beats me. (maybe someone can explain).

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[IRstuff]

Sure, that's easy, it's called....



















job security

TTFN

FAQ731-376