Howdy Joel.

i inserted your code, but nothing happended upon testing.

dose Target row = 1 and target coloum = 1 refer to cell A1 ?
Cheers
daragh.

"Joel" wrote:

You can use a worksheet_change event like below if you had only certain cells
you want to apply the 1.25 multplication


Sub worksheet_change(ByVal Target As Range)

Application.EnableEvents = False

If Target.Row = 1 And Target.Column = 1 Then
Target.Value = 1.25 * Target.Value
End If

Application.EnableEvents = True

End Sub


"D" wrote:

Cheers Joel.
But that would give me two coloums, one for the orignal value, the other
with the answer, I just want it so that I enter 10 in the cell, and it auto
adds 25% to it giving me 12.50, So bascaly in cell A1, if I type in 10 and
then click out of the cell, cell A1 should say 12.50.

Cheers thou

"Joel" wrote:

add another column. Add the data to cell A1, then if cell B1 have the
formula =1.25*A1

"macropod" wrote:

Hi D,

Enter 1.25 into an unused cell
Copy the 1.25
Select the range you want to increase by 25%
Choose Edit|Paste Special|Values|Multiply
Delete the 1.25 from the cell you entered it into.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"D" wrote in message ...
Howdy Folks.
Example

In cell A1
Can I enter any figure and then add 25% to it, but it updates in the same
cell, rather than adding two cells together.

Cheers.
D