Is it possible to have multiple hyperlinks in one cell (referencing say 5
different cells)?
Is it possible to have multiple hyperlinks in one cell (referencing say 5
different cells)?
Try this:
Assuming they are all in the same worksheet, select those cells and give
them a range name:
In the Name box (just above the Col_A heading) type: rngMultiCells, then
press [Enter]
Then, select your hyperlink cell.
Insert>Hyperlink
Click: Place in this document
Select the range named rngMultiCells
Click [OK]
Now, when you click the hyperlink....those cells should all be selected.
Does that help?
***********
Regards,
Ron
"Rednosebob" wrote:
> Is it possible to have multiple hyperlinks in one cell (referencing say 5
> different cells)?
It does what I needed. Thanks a bunch!
"Ron Coderre" wrote:
> Try this:
> Assuming they are all in the same worksheet, select those cells and give
> them a range name:
> In the Name box (just above the Col_A heading) type: rngMultiCells, then
> press [Enter]
>
> Then, select your hyperlink cell.
> Insert>Hyperlink
> Click: Place in this document
> Select the range named rngMultiCells
> Click [OK]
>
> Now, when you click the hyperlink....those cells should all be selected.
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
>
> "Rednosebob" wrote:
>
> > Is it possible to have multiple hyperlinks in one cell (referencing say 5
> > different cells)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks