The line break seems fine. When I tried it with the doubled up quotes it
put the correct formula into the cell.
On 5 June 2012 11:27, charlyRoot wrote:
> I tried that and it outputs the formula characters to the cell when I run
> it. Is my line break correct?
>
> Thank you for the quick reply.
It worked. Thanks.
On Monday, June 4, 2012 8:51:59 PM UTC-4, David Grugeon wrote:
>
> Probably need to double up all the quotes like
> "=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!R1C1,RC[-11]), ""Link""), ""
> "", )"
>
> On 5 June 2012 10:27, charlyRoot wrote:
>
>> This works fine in the spr
Nevermind. I tried it again and it worked. Must have had a quote messed up.
Sorry to waste time.
On Monday, June 4, 2012 8:51:59 PM UTC-4, David Grugeon wrote:
>
> Probably need to double up all the quotes like
> "=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!R1C1,RC[-11]), ""Link""), ""
> "", )
I tried that and it outputs the formula characters to the cell when I run it.
Is my line break correct?
Thank you for the quick reply.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
Probably need to double up all the quotes like
"=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!R1C1,RC[-11]), ""Link""), "" "",
)"
On 5 June 2012 10:27, charlyRoot wrote:
> This works fine in the spreadsheet:
> =SUBSTITUTE(HYPERLINK(CONCATENATE(statics!$A$1,B2), "Link"), " ","")
>
> However I can
This works fine in the spreadsheet:
=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!$A$1,B2), "Link"), " ","")
However I cannot escape the quotes correctly or something. I've tried every
combination and nothing.
Range("M2").Select
ActiveCell.FormulaR1C1 = _
"=SUBSTITUTE(HYPERLINK(CONCATENATE(statics!
