Calling a macro on worksheet_change

[tweek]

Hi, I´m having problems calling a macro.

Private Sub Worksheet_Change is located in sheet1

with the following code:


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$c$5" Then
Call Macro3
End If

End Sub



Macro3 is located in Module2 in the same workbook and works fine on its own with the following code:


Sub Macro3()
'
' Macro3 Macro
'
NewName = Range("c5").Value
name2 = Range("c6").Value
name3 = Range("c7").Value
ActiveSheet.Name = NewName & "_" & name2 & "_" & name3
End Sub



Nothing happens when I enter a valur into cell c5, any ideas what I´m doing wrong?

 

[Andrew Poulsom]

Equality is case sensitive:

If Target.Address = "$C$5" Then

 

[Nogslaw]

The address is case sensitive. Change it to:

If Target.Address = "$C$5" Then

 

[Domski]

As Target is a Range try:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("C5") Then
Call Macro3
End If
End Sub

Dom

 

[tweek]

thanks for the fast reply.. this works for me. I didn´t realize it would be case sensitive.

thanks again