Must say though, that the answer I provided is not VBA, but simply a formula
entered into cell C3? Do you really need a VBA routine to achieve the
result? Even then, I would merely use VBA to insert the formula in C3. Any
changes to A3 or B3 would then still be handled by the formula, and not by
VBA?

--
Hth

Kassie Kasselman
Change xxx to hotmail


"paul" wrote:

sorry its just a VBA programme, not an essay. so for all of that is
that all i would need to write in the programme. ?

how would i get bonus marks for error checking to ensure that a
negative value on "n" cannot be used?


thanks


On 22 Jul, 18:50, Helmut Weber wrote:
Hi Kassie,

=IF(B3="","",IF(B3<=0,"Integer in B3 must be positive",(A3^B3)/B3))

works perfectly, but

in essay formats !

is there no cell format "essay"?

;-)

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"