Hi Bob, I tried that and also Nigel's sugestion. These are what I tried, but
neither works:

Cells(pasterow, pastecol).FormulaR1C1 = "=HYPERLINK("C:\1. ACTIVE
CLIENTS\"&client_folder,client_folder)"

but i inserted some spaces to make it:
Cells(pasterow, pastecol).FormulaR1C1 = "=HYPERLINK("C:\1. ACTIVE
CLIENTS\" & client_folder, client_folder)"
neither works

From Nigel:
Cells(pasterow, pastecol).FormulaR1C1 = "=HYPERLINK("C:\1. ACTIVE
CLIENTS\" & client_folder & "," & client_folder & ")""
doesn't work.

Brett

"Bob Phillips" wrote:

=HYPERLINK("C:\1. ACTIVE CLIENTS\"&client_folder,client_folder)


--
__________________________________
HTH

Bob

"Brettjg" wrote in message
...
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!