Main Area and Open Discussion > Living Room

My first excel macro

(1/3) > >>

kalos:
Hello!

I want to write a macro in Excel that will use the 'Goal Seek' analysis.

The code is something like that:

Range("Q27").GoalSeek Goal:=0, ChangingCell:=Range("B10")

As for input cell (ChangingCell), when the macro button is pressed, I want to consider the active cell. How can I do that?
As for the goal seek cell, I want to a formula to calculate it based on other cells values.

Any hint?

Thanks!

KodeZwerg:
i do not want to scare some one off, i am sorry,
SpoilerYou really should consider to put your nose in a book.
If this is too expensive for you to learn, how about a visit to the public library?

Those are my Hints.

wraith808:
You really should consider to put your nose in a book.
If this is too expensive for you to learn, how about a visit to the public library?

Those are my Hints.
-KodeZwerg (October 09, 2018, 10:26 AM)
--- End quote ---

It's better not to answer, and let silence speak for itself, rather than to post snark, in my opinion.  DC remains a very open and inviting site, and some do seem not to help themselves.  But our responses to them can scare off others that we really could help.

kalos:
What I am asking is not a google search and I don't have the time now to read a whole tutorial

mouser:
It's better not to answer, and let silence speak for itself, rather than to post snark, in my opinion.  DC remains a very open and inviting site, and some do seem not to help themselves.  But our responses to them can scare off others that we really could help.
--- End quote ---

What Wraith said.  We must all remember to be kind and polite.  If you feel like someone should search for answer themselves, wither let your silence speak or give them some kind encouragement to go search for themselves... We try to avoid snark and sarcasm here, even though the current era we live in thrives on it.. it's just not the DC way :)

Navigation

[0] Message Index

[#] Next page