Hyperlink-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

One way:

Insert/Hyperlink, Link to: #A5:E15

In article ,
"Pawan" wrote:

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

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


"Pawan" wrote in message
...
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