-
I don't really understand why you've written the SelectionChange code the way you have. Target represents the cell that has just been selected - you shouldn't try to change that. I suggest you use:
[vba]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rMonitor As Range
Set rMonitor = Me.Range("C2
18")
'ERROR is here
If Not Intersect(rMonitor, Target) Is Nothing Then
Signature
End If
End Sub
[/vba]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules