Hi,

In the Worksheet_Change event, I evaluate with Intersect method where the
change take place. If not intersect is nothing, then I need to change format
in the cells BEFORE (the earlier selection). I guess I can do this if I can
"store" the Worksheet_SelectionChange Target.address and pick it up in the
Worksheet_Change event.

I don't want to store it as a temporary txt file, but solve the problem into
the VBA. How can this be done? If it can't with this approach, does anybody
know a better one?

/Kind Regards