Basic Hyperlinking

**Zathrus** · 03-13-2009, 01:47 PM

Hi everyone.

Just can't seem to get the code quite right even when copying from Excel's Help window. Can someone correct this code for me?

Please Login or Register  to view this content.

I get an error message that says:

Compile error:
Expected: line number or label or statement or end of statement

Thanks,
Z

**mdbct** · 03-13-2009, 02:08 PM

If you re trying to use the HYPERLINK function in excel the correct coding would be

Please Login or Register  to view this content.

Please note, there is no need to select the cell (Range("A01").Select in your code) in order to enter the formula in VBA.

**Zathrus** · 03-13-2009, 02:29 PM

I don't think I need the function...

I just need the simplest way to create a hyperlink from my current cell using a Macro.

**mdbct** · 03-13-2009, 02:46 PM

Try this one:

Please Login or Register  to view this content.

**Zathrus** · 03-13-2009, 03:27 PM

That's Much better.

But how would I do this just referencing the ActiveCell?

**mdbct** · 03-13-2009, 03:33 PM

Change the "Range("A1")"s to ActiveCell and you should be good to go.

**Zathrus** · 03-13-2009, 04:07 PM

Ok, that worked just fine.

Many Thanks.

Re: Basic Hyperlinking