Thread: I want to link a cell in the macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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


Reply With QuoteReply With Quote