Default property of Target

[tiredofit]

I have this code which activates when a cell on Sheet1 is changed.


Suppose I double-clicked cell A1.


Hovering the mouse over Target shows $A$1, as expected and the code runs through to teh function, without any problems.

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
    
    Call Module1.abc(rng:=Target)
    
End Sub

Here is Module1:

Option Explicit


Public Function abc(rng As Range)


    ' Do something

End Function

The query I have is, as I understand, the default property for Target is .Value.


But this fails:

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
    
    Call Module1.abc(rng:=Target.Value)
    
End Sub

even though if I hover the mouse over Target.Value, it still shows $A$1.


Why is that?


Thanks

 

[RoryA]

Your function expects a range, so you can't pass it a value.

 

[Norie]

'$A$1' is a string.

PS Do yo actually have the value '$A$1' in a cell?

 

[tiredofit]

Thanks, I understand now.

No I don't have the value $A$1 in a cell.

 

[Norie]

If you don't have the value $A$1 in the cell then how are you seeing that when you hover over.