activecell.formula = "=hyperlink(""http://www.microsoft.com"",""Click me"")"

But your question is kind of vague. You can pick up those strings (or even
pieces of those strings) from anything that you can get to using VBA.



Vlad wrote:

I want to create a formula using =hyperlink() using VBA - have you any
pointers on that?

--

Dave Peterson