| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB: inserting text into a cell (excel 03)
Thanks. That did the trick. Do you know a way to make it a
hyperlinked text rather than a formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB: inserting text into a cell (excel 03)
On Aug 4, 11:35*am, Jabberwocky
wrote: Thanks. *That did the trick. *Do you know a way to make it a hyperlinked text rather than a formula? Answering my own question: Sheets("Caseload").Range(sel$).Hyperlinks.add Anchor:=Sheets("Caseload").Range(sel$), Address:="http:// www.dc.state.fl.us/ActiveInmates/list.asp?DataAction=Filter&dcnumber=" _ & Range("L3").Value, TextToDisplay:=Application.WorksheetFunction.Prope r(Range("b3").Value) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Inserting text to a cell already containg text | Excel Worksheet Functions | |||
| Macro - Inserting text to a cell already containg text | Excel Discussion (Misc queries) | |||
| Inserting text from a cell in another tab | Excel Discussion (Misc queries) | |||
| Inserting text within a cell | Excel Discussion (Misc queries) | |||
| Automatically inserting text into a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
