E
Elijah
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
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