Home

How to insert a hyper ink to select multiple ranges in a shape (No VBA)

%3CLINGO-SUB%20id%3D%22lingo-sub-894713%22%20slang%3D%22en-US%22%3EHow%20to%20insert%20a%20hyper%20ink%20to%20select%20multiple%20ranges%20in%20a%20shape%20(No%20VBA)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894713%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20select%20multiple%20ranges%20by%20using%20hyper%20link%20in%20a%20shape%20in%20excel%3F%3C%2FP%3E%3CP%3Efor%20eg%3A%3C%2FP%3E%3CP%3EI%20have%20to%20select%20range(a1%3Ac5)%20and%20range(x1%3Aab5)%20by%20one%20click%20on%20the%20shape.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-894713%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-894964%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20hyper%20ink%20to%20select%20multiple%20ranges%20in%20a%20shape%20(No%20VBA)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420510%22%20target%3D%22_blank%22%3E%40Sameer_Kuppanath_Sulta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20simply%20try%20the%20following%20code...%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3ESub%20SelectRanges()%0ARange(%22A1%3AC5%2CX1%3AAB5%22).Select%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EAnd%20then%20assign%20this%20code%20to%20any%20shape%20of%20your%20choice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20attached%20for%20more%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-895005%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20hyper%20ink%20to%20select%20multiple%20ranges%20in%20a%20shape%20(No%20VBA)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895005%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420510%22%20target%3D%22_blank%22%3E%40Sameer_Kuppanath_Sulta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20excel%20%3CSTRONG%3Enamed%20range%3C%2FSTRONG%3E%20you%20can%20create%20a%20hyperlink%20that%20will%20select%20desired%20range%20in%20one%20click.%20This%20solution%20does%20not%20require%20VBA%20codes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20define%20your%20desired%20range%20in%20%3CSTRONG%3EName%20Manager%20%3C%2FSTRONG%3Eand%20simply%20call%20this%20Name%20in%20Hyperlink.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20sample%20file%20is%20attached%20for%20your%20reference.%26nbsp%3BPlease%20let%20me%20know%20if%20it%20works%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-925999%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20hyper%20ink%20to%20select%20multiple%20ranges%20in%20a%20shape%20(No%20VBA)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-925999%22%20slang%3D%22en-US%22%3E%3CP%3ET%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%20This%20is%20what%20I%20looked%20for.%20Thanks%20a%20lot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926048%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20hyper%20ink%20to%20select%20multiple%20ranges%20in%20a%20shape%20(No%20VBA)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420510%22%20target%3D%22_blank%22%3E%40Sameer_Kuppanath_Sulta%3C%2FA%3E%26nbsp%3BYou%20are%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Sameer_Kuppanath_Sulta
Contributor

How to select multiple ranges by using hyper link in a shape in excel?

for eg:

I have to select range(a1:c5) and range(x1:ab5) by one click on the shape.

 

4 Replies
Highlighted

@Sameer_Kuppanath_Sulta 

 

You can simply try the following code...

Sub SelectRanges()
Range("A1:C5,X1:AB5").Select
End Sub

And then assign this code to any shape of your choice.

 

Please refer to the attached for more details.

 

 

Highlighted

Hi @Sameer_Kuppanath_Sulta 

 

Using excel named range you can create a hyperlink that will select desired range in one click. This solution does not require VBA codes.

 

Just define your desired range in Name Manager and simply call this Name in Hyperlink.

 

A sample file is attached for your reference. Please let me know if it works for you.

 

Thanks

Tauqeer

Highlighted

T@tauqeeracma  This is what I looked for. Thanks a lot

Highlighted
Related Conversations
Force to select a staff member at bookings
koppenburg in Microsoft Bookings on
1 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Userform Listbox HELP
R3d3mpt10n in Word on
1 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies