View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Calling certain functions within VBA

Application.WorksheetFunction.Max (...

You can use the most worksheetfunctions like this in VBA James

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"james" wrote in message ...
Simple question:

I'm writing a program where I want to use the following
functions within VBA code:

1. ln
2. Max
3. Abs

I forgot the code modifier that I need to insert to make
these common worksheet functions available to my VBA
programs.

Can anyone refresh my memory. I sincerely thank you!!!!!!