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 7:12 AM, charlyRoot wrote:
I don't know VBA
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 = _
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,
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
2012 10:27, charlyRoot c...@jwsre.com wrote:
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