Forum Discussion

Sameer_Kuppanath_Sultan's avatar
Sameer_Kuppanath_Sultan
Brass Contributor
Oct 05, 2019

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

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.  
excel
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Oct 05, 2019

Hi Sameer_Kuppanath_Sultan 

 

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

Resources