Oct 04 2019 09:24 PM
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.
Oct 05 2019 05:56 AM
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.
Oct 05 2019 07:24 AM
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
Oct 21 2019 10:55 PM
T@tauqeeracma This is what I looked for. Thanks a lot
Oct 21 2019 11:40 PM
@Sameer_Kuppanath_Sultan You are welcome.