Hyperlink-Pawan

[Pawan]

Hi...
I have one worksheet. My requirement is :
Upon clicking cell A1, portion through cell A5 to E15 should get selected,
in the same worksheet. I want to create hyperlink in cell A1. But I dont know
how to do this? Can anybody help me.
Thanks in advance.

-Pawan

 

[JE McGimpsey]

One way:

Insert/Hyperlink, Link to: #A5:E15

 

[Mangesh Yadav]

use the following code in the module of the concerned sheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
Range("A5:E15").Select
End If
End Sub

Mangesh