S
SDH
how do i enter a hyperlink to a specific cell with a excel workbook
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
SDH
how do i enter a hyperlink to a specific cell within an excel workbook
P
pietlinden
how do i enter a hyperlink to a specific cell within an excel workbook
Is this from Access? Otherwise, why not post in an Excel NG?
S
SDH
The hyperlink will be in access--------- to a cell in excel.
P
pietlinden
Set the Subaddress property of the hyperlink to the cell you want to
set the focus to, e.g. "C3" (but without the quotes)...
I wonder if that works with bookmarks in Word... (might have to try
it...)
set the focus to, e.g. "C3" (but without the quotes)...
I wonder if that works with bookmarks in Word... (might have to try
it...)
S
SDH
ok........ I'm a rookie......... how do i set the sub address?
P
pietlinden
ok........ I'm a rookie......... how do i set the sub address?
Okay....
When you create a hyperlink, there are two parts to the address
Hyperlink Address
Hyperlink Subaddress
So say you create a link to \\Netshare\subdirectory\SomeFile.XLS
Then you want to set focus to a specific cell, say Z15
Hyperlink Address would be \\Netshare\subdirectory\SomeFile.XLS
then subaddress would be the specific cell you wanted to go to: Z15