Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quotation Marks
Blimey, I'll bet I'm not the first to trip up on these! After two hours, I
give in and defer to your superiority! Using a subroutine I want to create a formula in (say) cell A1. I want the formula in the cell to read: =HYPERLINK("C:\1. ACTIVE CLIENTS\Duke, E","Duke, E") but the thing is that Duke, E is a variable. This is set by coding client_folder = surname & ", " & initial I know that this works: Cells(pasterow, pastecol).FormulaR1C1 = "=HYPERLINK(""C:\1. ACTIVE CLIENTS\Duke, E"",""Duke, E"")" so now I need the code to replace Duke, E with client_folder. Help me, pleeeeeeeeeeeease! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quotation Marks? | Excel Worksheet Functions | |||
Quotation Marks - When and What?? | Excel Discussion (Misc queries) | |||
quotation marks | Excel Worksheet Functions | |||
quotation marks | Excel Programming | |||
Using quotation marks | Excel Programming |