Hi,
Im trying to Call a macro in vba automatically when the value of cell A3 is changed.
The macro runs, but when its finished I get the Run-time error 13 - Mismatch
Now I read on different places that this means for instance a string and a number are mixed up in a formula.
I just don't see how this applies here.
This is the code. The line in red shows where the error comes from.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$3" And Target.Value < 8 Then
Range("C4:C375").Select
Selection.UnMerge
Call Version2
End If
End Sub
I hope you can help me
Im trying to Call a macro in vba automatically when the value of cell A3 is changed.
The macro runs, but when its finished I get the Run-time error 13 - Mismatch
Now I read on different places that this means for instance a string and a number are mixed up in a formula.
I just don't see how this applies here.
This is the code. The line in red shows where the error comes from.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$3" And Target.Value < 8 Then
Range("C4:C375").Select
Selection.UnMerge
Call Version2
End If
End Sub
I hope you can help me
