writing a hyperlink into a cell

[tryer]

I have a section of code which seperates document names into a variable called filenames and writes them to various cells, the line of code that currently writes the text is:

Please Login or Register  to view this content.

the value for "filename" is a document name. What I would like is to write a hyperlink to this filename in the cell rather than just the name
I have tried recording a macro (say =hyperlink(A2) ) but the code generated doesn't seem to help me
can anyone help with this?

Thanks

[sweep]

Hi,

Try this:

Please Login or Register  to view this content.

[tryer]

Thanks Sweep, But I am getting an error message:
Runtime error 5 - invalid procedure or call

I guess this is to do with the address. I have tried replacing address=filename with address = thisworkbookpath but get the same error

[sweep]

It's working fine in the posted fomat for me with filename set as some excel file such as

filename = "C:\test.xls"

[tryer]

Sweep,

Sorry it was me being Dull

It does work fine, thanks very much