Simple goal seek macro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal seek - column reference 3
macro Help 3
Loop several sheets - part 3 - Dave Peterson - Goal seek 4
Do Loop Goal Seek won't End Sub 2
vba goal seek 2 1
Using Goal Seek without a macro 1
Goal Seek with dynamic Goal Seek 1
Goal Seek 1

Top