change value in cell by sum

[Harry Hof]

Hi there,

For almost a couple a day's I' am trying to find an solution in excel 2010 but so far no good. I 'am a newbie in VBA so that is possibile one reason why many tryings doesn't work good.

What I like to find is an macro with do an calculation of an value in an cell (example: 100,5 * 1,19 OR 45 * 1,19). All the value's to calculate with are in the same colom and I like to change the value in the same cell with te outcome of the calculation.

example:
the colom before running a macro:

A
1 100,5
2 45
3 1125
4 50,5

The colom after running a macro (always ..*1,19):

A
1 119,60
2 53,55
3 1338,75
4 60,01

Can somebody helping me on how to make an good macro for this.

Kind regards,
Harry Hof