auto adjust cell formula

redspanna · Mar 14, 2011

Hi all

In cell A1 I have a simple formual that at certain times I want it to be changed to add a value of 7

So the formula at the moment is

Code:

=$B384

when my macro is run I want that formula to be then increased by 7 so on this example A1 would now be

Code:

=$B391

any ideas how to incorportae this into my code?

thanks

Joe4 · Mar 14, 2011

Here is a small snippet code that should do that. Modifed to suit your needs.

Code:

Sub MyIncrementFormula()
'   Change formula in cell A1 to increase it by seven rows every time this macro is run
    Range("A1").Formula = "=$B" & Right(Range("A1").Formula, 3) + 7
   
End Sub

redspanna · Mar 14, 2011

Hey Joe4

thats just perfect..thanks so much for taking the time to help with my post

regards

auto adjust cell formula

redspanna

Well-known Member

Excel Facts

Joe4

MrExcel MVP, Junior Admin

redspanna

Well-known Member

Similar threads

Forum statistics

Share this page

auto adjust cell formula

redspanna

Well-known Member

Excel Facts

Joe4

MrExcel MVP, Junior Admin

redspanna

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock