Hyperlink Error - Need Help!

[avadhutd2]

Hi,

I am using following code to have hyperlink to a cell, but I am getting an error "An unexpected error has occurred".

What can be wrong in this context even if we have the file path correctly entered?

I had attached a sample file with the hyperlink code in sheet1. I need to generalize this code once it starts working.

If possible, can anyone correct the code or let me know the steps to be followed in order to get this working.

Thanks in advance...

[p45cal]

Works here fine. Perhaps a long shot but how about
[vba]Address:= Chr(34) & Sheet1.Cells(1, 1).Value & Application.PathSeparator & Sheet1.Cells(1, 2).Value & Chr(34)[/vba]

[mike31z]

in cell c1 try "=hyperlink(A1,B1)


Mike.