how not to go on Loop
hi,
I am trying to do a button that run a goalseek function. the thing is: Range("D21").GoalSeek Goal:=x, ChangingCell:=Range("D14") the valeu X gotta be the ("D21") Value, rounded by 0 exemple if ("D21") is "12.32" X = 12 any way, i cant manage to doit without creating a loop, because as soons as D21 is 12, X=0 i was able to make it wokr with a nasty copy and past.value way, but would like to learn some other way... Thanks in advance... |
how not to go on Loop
I actualy was able to manage not looping the macro.
but I have a different ptoblem now... my code is Sub Goal () Dim total As Long With Worksheets("Plan1") total = .Cells("11", "F").Value 'MsgBox (total) Range("F11").GoalSeek Goal:=total, ChangingCell:=Range("D5") End With End sub the new problem is: if "F11" is smaller than 0.5 , it the long variable rounds down. if its higher that .05 it rounds up. I always need to be rounded down, even if my "F11" is 0.999999 i thank in advance for the help if my "Paulo" wrote: hi, I am trying to do a button that run a goalseek function. the thing is: Range("D21").GoalSeek Goal:=x, ChangingCell:=Range("D14") the valeu X gotta be the ("D21") Value, rounded by 0 exemple if ("D21") is "12.32" X = 12 any way, i cant manage to doit without creating a loop, because as soons as D21 is 12, X=0 i was able to make it wokr with a nasty copy and past.value way, but would like to learn some other way... Thanks in advance... |
All times are GMT +1. The time now is 04:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com