| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| using macro that will link into web | Excel Discussion (Misc queries) | |||
| How do I link a check box to a macro? | Excel Worksheet Functions | |||
| Macro updates and link goes #REF! ??? | Links and Linking in Excel | |||
Linear Mode
