Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2012
Office Development in Visual Studio
Create Add-ins and Customizations for Office by using Visual Studio
Managed Reference (Office Development in Visual Studio)
Microsoft.Office.Tools.Excel
XmlMappedRange Interface
XmlMappedRange Methods
_PasteSpecial Method
_PrintOut Method
Activate Method
AddComment Method
AllocateChanges Method
AutoComplete Method
AutoFilter Method
AutoOutline Method
BorderAround Method
BorderAround2 Method
Calculate Method
CalculateRowMajorOrder Method
CheckSpelling Method
Clear Method
ClearComments Method
ClearContents Method
ClearFormats Method
ClearHyperlinks Method
ClearNotes Method
ClearOutline Method
ColumnDifferences Method
Consolidate Method
Copy Method
CopyFromRecordset Method
CopyPicture Method
CreateNames Method
CreatePublisher Method
Cut Method
DataSeries Method
DialogBox Method
Dirty Method
DiscardChanges Method
EditionOptions Method
ExportAsFixedFormat Method
FillDown Method
FillLeft Method
FillRight Method
FillUp Method
Find Method
FindNext Method
FindPrevious Method
FunctionWizard Method
get_Address Method
get_AddressLocal Method
get_Characters Method
get_End Method
get_Item Method
get_Offset Method
get_Range Method
get_Resize Method
get_Value Method
GetEnumerator Method
GoalSeek Method
Group Method
Insert Method
InsertIndent Method
Justify Method
ListNames Method
Merge Method
NavigateArrow Method
NoteText Method
Parse Method
PasteSpecial Method
PrintOut Method
PrintOutEx Method
PrintPreview Method
RemoveDuplicates Method
RemoveSubtotal Method
Replace Method
RowDifferences Method
Run Method
Select Method
set_Item Method
set_Value Method
SetPhonetic Method
Show Method
ShowDependents Method
ShowErrors Method
ShowPrecedents Method
Speak Method
SpecialCells Method
SubscribeTo Method
Subtotal Method
Table Method
TextToColumns Method
Ungroup Method
UnMerge Method
Expand Minimize
This topic has not yet been rated - Rate this topic

XmlMappedRange.GoalSeek Method

Visual Studio 2012

Calculates the values necessary to achieve a specific goal.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
C#
VB
Copy 
bool GoalSeek(
	Object Goal,
	Range ChangingCell
)

Parameters

Goal
Type: Object

The value you want returned in this cell.

ChangingCell
Type: Range

Specifies which cell should be changed to achieve the target value.

Return Value

Type: Boolean
true if the goal seek is successful; otherwise false.

If the goal is an amount returned by a formula, this calculates a value that, when supplied to your formula, causes the formula to return the number you want.

The following code example uses the GoalSeek method to find the cubic root of 27 and places the answer in cell A1. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerAddress1Cell with a corresponding schema element of type int.

C#
VB
Copy 
private void SolveFormula()
{
    this.CustomerAddress1Cell.Formula = "=(A1^3)";
    this.CustomerAddress1Cell.GoalSeek(27, this.Range["A1"]);
}
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.