Peter

Me too, but one of the "methods" is List of Worksheet Functions Available to
Visual Basic. Click on that it will give you all 200 or so functions that
you can access via the WorksheetFunction object. That's in XL2000, so if
you're using a different version, it may be different.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Peter Chatterton" wrote in message
.. .
Thanks Dick, but when I looked up WorksheetFunction Object Methods
(from F1 in the macro editor) it only gave me 5 methods.
Peter.

"Dick Kusleika" wrote in message
...
Peter


Two questions:
How can you say Application.Substitute
without saying WorksheetFunction?

See here http://www.dicks-blog.com/excel/2004...rksheetfu.html


Where are these functions in VBA help?


If you look up the WorksheetFunction object in VBA help, then click on
the
Methods link, you can get a list of functions available.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com