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

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

Sameer_Kuppanath_Sultan 

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.