View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul3rd Paul3rd is offline
external usenet poster
 
Posts: 28
Default Run Time Error '91'

Hello,
The following code causes Run Time Error '91' when I insert it into
worksheets.
The code allows comments to be shown when cell is active.
Can anyone help?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("B4").Comment.Visible = Not (Intersect(Target, Range("B4")) Is
Nothing)
End Sub
Thanks in advance for any help,
Paul