PERFECT!! Thank you very much! I knew there was something out there I
haven't found yet.
On Tuesday, June 5, 2012 10:57:07 AM UTC-4, Sandeep Kumar Baranwal wrote:
>
> Refer
> functionx.com/vbaexcel
>
> this will help
>
> Sandeep
>
>
> On Tue, Jun 5, 2012 at
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""), ""
> "", """"
[-11]), ""Link""), ""
> "", """")"
>
> On 5 June 2012 10:27, charlyRoot wrote:
>
>> This works fine in the spreadsheet:
>> =SUBSTITUTE(HYPERLINK(CONCATENATE(statics!$A$1,B2), "Link"), " ","")
>
I don't know VBA other than manipulating recorded macros. What is the quickest
way to learn from foundation up? Book? Some pay site? It takes to long to go
through youtubes.
I would like a info dense book that does not assume prior prior VBA knowledge
but also assumes I know what a keyboard is
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
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!
