Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
the following snippet of code does not work becaus the equal sign
within the quotes creates an error. If i precede the equal sign with an apostrophe, the apostrophe is inserted into the cell, causinng the formula to be interpreted as text.. Sheets("Caseload").Range(sel$).Value = "=Hyperlink(http:// www.dc.state.fl.us/InmateReleases/list.asp?DataAction=Filter&dcnumber=" & Range("L3").Value & "," & Application.WorksheetFunction.Proper(Range("b3").V alue) & ")" Is there a more elegant way of pasting a value, and making it a hyperlink? I don't really need to have a formula in the cell if the VB script can create the hyperlink. Pardon my poor terminology (self-taught) --Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |