I am trying to write a code in vba to change a target cell by a user defined percentage which already contains a value.

As an example.

If N12 contains a value of 100 and G4 contains the 6% increase, i want the contents of cell N12 to increase to the value of (100 + 6 %) 106. Also I then wish to repeat this down from N12 to as many cells as required all using G4 as the target % increase.

Any help or suggestions, or even someone who can write the VBA code and post would be most appreciated.