Link to home
Start Free TrialLog in
Avatar of excel learner
excel learnerFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Hyperlinking name range

Dear experts,

I have workbook in the one of the sheets i have in column A list of name ranges

IS there a way i can hyper link the name ranges in column A in sheet 'name range' to the range where it refers to

for example in sheet 'name range'

column A cell A5 value is 'BSM_1_1'
Coumn B cell B5 i have the range value is  ='xyz'!$C$70

Now i want a macro which will create a hyperlink under cell B5 which when i click will take me to the range where it referred.

IF a solution can be made available whereby if a macro is provided which create a list of all name ranges, specificy the name and hyper link it automatically, will also be a nice one.

Thankyou


Avatar of SiddharthRout
SiddharthRout
Flag of India image

If you can upload a sample sheet then I be able to give you the code promptly else I will have to create a sample :)

Sid
Avatar of excel learner

ASKER

Siddarth thank you for your comment.
Let me put the question a little differently.

If i have  value in cell A1 in sheet 1, ='xyz'!$C$70

and i f i have a sheet XYZ in the same work book,

then is it possible to put a hyperlink under ='xyz'!$C$70
 and when i click on it will go to cell c70 in sheet xyz.

thank you,

ASKER CERTIFIED SOLUTION
Avatar of Jan Karel Pieterse
Jan Karel Pieterse
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
jkpieterse,

thank you for the formulae, the hyperlinking is activated, but when i click i got the error message as appearing in the attached.

kindly help

Thank you


excel-security-message.doc
I have seen that happen before, but not with links internal to Excel. I'm sorry I do not know (at the moment) if you can suppress that message.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial