I want to link a cell in the macro

[karthi.nitk]

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

 

[Guest]

Try something like this:

Target = Range("E15") / 100
Range("L39").Select
Range("L39").GoalSeek Goal:=Target, ChangingCell:=Range("L43")