I want to link a cell in the macro
 

I am trying to edit the macro: In the syntax given below I just want
to change the hard wired 0.12 to be linked to a cell and that cell
number is divided by 100.

For Ex : I have cell E15=12
and here in stead of 0.12 I want it to be linked to "E15/100".

Help me witht he syntax for the same.


Range("L39").Select
Range("L39").GoalSeek Goal:=0.12, ChangingCell:=Range("L43")
Range("L43").Select

I want to link a cell in the macro
 

Try something like this:

Target = Range("E15") / 100
Range("L39").Select
Range("L39").GoalSeek Goal:=Target, ChangingCell:=Range("L43")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
I am trying to edit the macro: In the syntax given below I just want
to change the hard wired 0.12 to be linked to a cell and that cell
number is divided by 100.

For Ex : I have cell E15=12
and here in stead of 0.12 I want it to be linked to "E15/100".

Help me witht he syntax for the same.


Range("L39").Select
Range("L39").GoalSeek Goal:=0.12, ChangingCell:=Range("L43")
Range("L43").Select