Peter,

Can you post the code?

Naomi


"Peter Ostermann" wrote in message
...
Hi experts,
to allow to insert a value in just one of two cells of 2 columns
the "intersect" method of VBA is a solution that works. When
is inserted a number in one of the cells, the corresponding
cell can be set blank by VBA code.

The problem is, that when a number of cells is selected
and at once copied to a range of thaat cells or to a single cell of
the "intersect" controlled columns (or one cell is dragged for
copy purpose to a range of that cells), it does not work.
The content of the corresponding cells isn't set blank
in this case, or even an error happens.

Is there any workaround possible?
Tanks in advance for any hint.

Regards
Peter Ostermann