Forum Discussion

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

Subodh_Tiwari_sktneer

Silver Contributor

Oct 05, 2019

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.

Select Ranges.xlsm14 KB