Hi. You're so close. One technique is to record your macro like you are
doing. Then, go back and edit your macro.
You can set your "Goal" based on another cell by taking the Value of that
cell (D1 in this example)

Sub Demo()
'// Recorded Macro
Range("A1").GoalSeek Goal:=100, ChangingCell:=Range("B1")

'// Make your changes here...
Range("A1").GoalSeek Goal:=Range("D1"), ChangingCell:=Range("B1")
End Sub

HTH :)
--
Dana DeLouis
Win XP & Office 2003


"gvm" wrote in message
...
I'm trying to record a macro that automates the use of GoalSeek. My
procedure
starts by 1) start macro recording, 2) go to Tools menu and invoke Goal
Seek,
3) set the target cell by clicking on the appropriate cell, and 4) is
where I
have a problem. The need is to enter a value from a cell in the
spreadsheet
but it appears the value must be manually read and then typed in via the
keyboard. For instance, the field does not accommodate a context menu thus
the opportunity to copy and paste into it is blocked. Is there are way
around
this?