| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quotes in .formula calcs
I would like to put:
HLRange.Formula = "=Hyperlink('file:\\Server1\test.pdf')" in code but I get a run time error-1004 message, can someone help with the formatting on this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quotes in .formula calcs
HLRange.Formula = "=Hyperlink(""file:\\Server1\test.pdf"")"
You have to double up your double quotes inside that string. Paulymon wrote: I would like to put: HLRange.Formula = "=Hyperlink('file:\\Server1\test.pdf')" in code but I get a run time error-1004 message, can someone help with the formatting on this. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where to put quotes in a SUMIF formula and when is & used for cell | Excel Discussion (Misc queries) | |||
| Formula help on Exit Calcs | Excel Discussion (Misc queries) | |||
| change straight quotes to curly quotes | Excel Discussion (Misc queries) | |||
| Quotes in formula | Excel Programming | |||
| Formula with quotes and ampersand | Excel Programming | |||
Linear Mode
