Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple goal seek macro
Hello,
I'm fairly new to VBA I hoping I can get some help with excels goal seek function. I've recorded a macro to automate the goal seek function, but I'd also like to expand it to incorporate some sort of IF statement. So far I have: Range("C443").GoalSeek Goal:=Range("B443"), ChangingCell:=Range("B331") End Sub What I'd like to do is run: IF cell A1 is TRUE, than run goal seek 1 (as above), if not TRUE than run goal seek 1. Any help appreciated Elijah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal seek via macro? | Excel Discussion (Misc queries) | |||
Goal Seek in a Macro | Excel Discussion (Misc queries) | |||
simple yet complex scenario - goal seek problem | Excel Worksheet Functions | |||
Can I build 'goal seek' facility into a macro? | Excel Discussion (Misc queries) | |||
Goal Seek tool in a macro | Excel Discussion (Misc queries) |