我要在excel里面插入图片，第一列和第二列都有款号，我想点击任何单元格均显示图片

JAYONE

Private Sub Image1_Click()
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim n$
On Error Resume Next
n = "图片地址\" & Cells(Target.Row, 1).Value & ".jpg"
Image1.Picture = LoadPicture(n)
Image1.PictureSizeMode = fmPictureSizeModeZoom
Image1.PictureAlignment = fmPictureAlignmentCenter
End Sub


现在的问题是只有第一列的款式能显示图片，第二列的款式不显示？  因为有的款式图片在第一列有的在第二列