Please explane more what you want Alex

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



"alex" wrote in message ...
I am trying to determine a syntax for entering formula
using VBA.
For example if
Dim apple as range
Set apple =("b1:b5")
how to make B6 property averaging apple.
Thanks,
Alex