short cut to application.worksheetfunction.XYZ
short cut to application.worksheetfunction.XYZ
(OP)
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).
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.
RE: short cut to application.worksheetfunction.XYZ
job security
TTFN
FAQ731-376: Eng-Tips.com Forum Policies