Log in

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.