Hyperlink Help

**xdarkfluxx** · 08-07-2009, 08:21 AM

How do you add a hyperlink to the active cell and have it point to a named cell on a different sheet?

**Palmetto** · 08-07-2009, 08:35 AM

Assuming you've created the named cell, in the cell holding the hyperlink press Ctrl+K keys, choose "Place in this document" and pick the name from the list of defined names.

**xdarkfluxx** · 08-07-2009, 08:39 AM

I want to do it with excel vba because I have over 1000 rows to go though.

**sweep** · 08-07-2009, 10:33 AM

Hi,

Try this...

Please Login or Register  to view this content.

Where Sheet2!B3 is the cell to link to.

**Rick_Stanich** · 08-07-2009, 10:57 AM

Basic Named Cells example with a couple images in a zip file.
A benefit using named cells is, if you add or remove rows and or columns, the hyperlink takes you to the cell instead of the cell address.

HTH