PDA

View Full Version : Hyperlink Error - Need Help!



avadhutd2
02-25-2010, 07:01 AM
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
02-25-2010, 09:42 AM
Works here fine. Perhaps a long shot but how about
Address:= Chr(34) & Sheet1.Cells(1, 1).Value & Application.PathSeparator & Sheet1.Cells(1, 2).Value & Chr(34)

mike31z
02-25-2010, 10:32 AM
in cell c1 try "=hyperlink(A1,B1)


Mike.