select only a portion of a cell value

[GSMike]

Relating to my other question, "Set the state of a cell to edit", is there any way to select just a portion of a cell value.
For example, cell A1 reads

=Personal.xls!Quincy(EnterRangeHere)

Is there any way to have the cell set to edit mode and have "EnterRangeHere" highlighted so the user can just start typing in the range as soon as the shortcut key produces the text?
Thanks again.
-Mike

 

[JVFriederick]

Can you request the desired range and THEN create the formula into A1 ? (I could only search and replace to get rid of the ' marks in the new formula.) If someone else knows how to accomplish this .... jump in !


RangeDesired = inputbox("Enter the desired Range&quot
ComboLink = "=+[Personal.xls]Quincy!" + RangeDesired

Range("A1&quot.Select
ActiveCell.FormulaR1C1 = ComboLink

Selection.Replace What:="'", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False