Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic Excel functionality collides with VBA code.
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting Code in Visual Basic Editor (Excel 2003) | Excel Worksheet Functions | |||
Essbase over-rides basic Functionality? | Excel Programming | |||
Visual basic Code or editor won't load in Excel | Excel Programming | |||
How do I hide my Visual basic code in Excel? | Excel Programming | |||
Visual Basic Code in Excel | Excel Programming |