Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) | |||
How can I extract hyperlink value | Excel Discussion (Misc queries) |