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
|