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.

Hi
I don't know about VBA, but this works:
If you can enter in an empty cell the value 1,06 - copy it -select the range to increase - Paste special - Multiply - OK

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post