Dynamic and Static in formula
Posted on 2013-12-28
Merry Christmas and Pre-Happy New Years to All.
Quick question about how to combine a static and dynamic formula in vba.
Here is what I have so far:
Dim r as String
r = target.row
Dim a as String
a = Target.Address
This is just for the "right hand side of the equation." The left hand side is already done and fine.
"=((sheet1!T4)/(Sheet2!AF5 + Sheet3!AT3)) "/sheet4!AM" & r & "
So T4, AF5, and AT3 are all static meaning that the program should use these cells all the time. In other words, $T$4, $AF$5, and $AT$4.
AM is the dynamic and slides up and down the range relative to the trigger.
Anybody want to take a quick shot at this? I know I almost have it but I think my problem is around the sheet!4AM part and specifically the "dividing" part "/".
thanks for you input.