Name of a Sheet in a Macro linked to a cell.

[Moises Munoz]

What should be the code in order to link the name of a
sheet with a cell ?

For example :

Sheets("Target").Select
Range("I19").GoalSeek Goal:=Sheets("Anexo C").Range("R9"),
ChangingCell:=Range("H11")


The name of the Sheet "Target" should be typed into the
cell "B5" of sheet "Anexo C" .

Thanks and regards,

Moises

 

[Bob Phillips]

Moises,

You can do this with a worksheet formula. In B5 enter

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)