PDA

View Full Version : Solved: Working With Named Ranges



LarryLaser
10-18-2006, 11:33 AM
How do I change this piece of code to function with named ranges?
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'needs to target Range Name "Pics"
If Target.Column = 7 Then ViewPicture Target

Bob Phillips
10-18-2006, 12:34 PM
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'needs to target Range Name "Pics"
If Not Intersect(Target, Range("Pics")) Is Nothing Then
ViewPicture Target.Value
End If

LarryLaser
10-18-2006, 01:09 PM
Awsome,
Thanks xld

btw, I like your new avatar.

Bob Phillips
10-18-2006, 03:11 PM
btw, I like your new avatar.

Coutesy of Simon Lloyd.