VBA- Use an event to store a value

[kgkev]

i am trying to store a value to a global variable using

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
lastvalue.Value = Target.Value
End Sub

lastvalue is declared as a string in a module.

I get a Complile Error - Invalid qualifier.

Any idea what is causing this?

Checked and its not just a spelling mistake.

 

[kgkev]

any way to overcome it without unmerging all my cells?

 

[VoG]

Try

lastvalue = Target(1).Value

 

[kgkev]

Spot on - Thanks for that