Recover Lost Data with MicroSD Card Recovery : Troubleshoot:Delete content of a cell after updating another one

Monday, September 26, 2016

Delete content of a cell after updating another one

Hi

I have 2 columns . Data goes from A10 to B2000

I would like some code to do the following.

As exemple: If I change content in cell A134, automatically content of cell B134 is erase or delete. If I change content in cell A22, content of cell B22 is automatically delete

Thanks for helping

Anwsers to the Problem Delete content of a cell after updating another one

Download SmartPCFixer for Free Now

Shight-click the sheet tab and select View Code from the context menu.
Add code like this to the module that appears:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("A10:A2000"), Target) Is Nothing Then
Intersect(Range("A10:A2000"), Target).Offset(0, 1).ClearContents
End If
End Sub

Check Windows System Requirements

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

Another Safe way to Repair the Problem: Delete content of a cell after updating another one:

How to Fix Delete content of a cell after updating another one with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.