How do I change this piece of code to function with named ranges?
[vba]Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'needs to target Range Name "Pics"
If Target.Column = 7 Then ViewPicture Target
[/vba]
How do I change this piece of code to function with named ranges?
[vba]Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'needs to target Range Name "Pics"
If Target.Column = 7 Then ViewPicture Target
[/vba]
LarryLaser
neogeek in training
[vba]
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[/vba]
Awsome,
Thanks xld
btw, I like your new avatar.
LarryLaser
neogeek in training
Coutesy of Simon Lloyd.Originally Posted by LarryLaser