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.

 

[VoG]

It should be

lastvalue = Target.Value

 

[njimack]

Wouldn't it just be lastvalue = Target.Value ?

 

[kgkev]

grrrrr

This gives a runtime error 13 - type mismatch?

 

[kgkev]

as a test this give the same error

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

 

[njimack]

What does Target.Value actually contain?

 

[VoG]

What is the value of Target when that occurs?

Maybe Dim lastval as Variant.

 

[kgkev]

Could be anything other than a formula

Blank, number or text

 

[kgkev]

got it - My cells are merged on quite alot of my sheet.

If there a way to overcome this?

 

[VoG]

Try this http://www.mrexcel.com/forum/showthread.php?t=335123