Hi all,

This is (part of) what I have:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim Kpl as long

If Target.Value < "" Then Kpl = Target.Value

....

I hope this is enough to answer the following question.

If I press delete, therefore starting the event, the variable does not yet
have a value and according to the line of code in the if-construct, it won't
get a value either.

How can you use this state of "emptyness" the variable has at that time if
you want to do something like a test and you do not want this "emptyness" to
be confused with 0?

Thanks,
Peter