View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] karthi.nitk@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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