VBA & Macro Problems

Use Excel VBA Intersect to Detect Changes in Column C

Tauseeq MagsiTauseeq Magsi Nov 20, 2026 869 views

Question details

Run VBA code when an edited cell or range includes any cell in column C.

Detect Changes in Column C with Excel VBA Intersect
Product
Microsoft Excel VBA
Device & OS
not provided
Scenario
A worksheet needs to respond to changes anywhere in column C rather than checking one fixed cell address.
Observed behavior
The desired code runs when the worksheet change target overlaps column C, including when multiple cells are changed at once.
Before you start

Open the workbook in a desktop version of Excel that supports VBA and identify the worksheet to monitor. Save the workbook as an Excel Macro-Enabled Workbook (.xlsm) and enable macros if prompted and you trust the file.

Solution 1Recommended

Use Intersect in the worksheet's change event

Use this approach to run an action whenever a changed range overlaps column C on a specific worksheet.

1
Open the worksheet code

Right-click the worksheet tab you want to monitor and select View Code.

2
Add the change event

In the worksheet's code window, enter: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Me.Columns(3)) Is Nothing Then ' Add your required actions here. End If End Sub

3
Add and test your action

Replace the comment inside the If block with your VBA action. Return to the worksheet and edit or paste into a cell in column C to test it.

4
Save the macro

Select File > Save As and choose Excel Macro-Enabled Workbook (.xlsm) if the workbook is not already saved in that format.

Use Intersect in the worksheet's change event
Changes and recalculation: Worksheet_Change handles edits and changes made by external links, but it does not fire when a formula result changes during recalculation. Use Worksheet_Calculate if you need to respond to recalculation.
Free Microsoft Office alternative

Edit spreadsheets with WPS Office

WPS Office is a free, lightweight alternative for everyday spreadsheet work. Its familiar interface and Microsoft Office format compatibility make it easier to move existing files, although it does not fix Excel VBA event issues and macro support can vary.

Edit and review spreadsheet data in a familiar interface.Work with Microsoft Excel formats such as XLSX and XLS.Move existing spreadsheets into a lightweight office suite.Review column C data without setting up an Excel change event.
microsoft office alternative - wps office

Frequently Asked Questions

Will this detect a paste that includes several cells?

Yes. Target can contain multiple cells, and Intersect(Target, Me.Columns(3)) detects whether any part of that range overlaps column C.

Where should I put the Worksheet_Change code?

Right-click the worksheet tab, select View Code, and place the event procedure in that worksheet's code window, not in a standard module.

Why doesn't the event run when a formula recalculates?

Worksheet_Change does not fire for recalculation alone. Use the worksheet's Worksheet_Calculate event if you need to respond when formulas recalculate.

Why does Excel remove my VBA code when I save?

The standard .xlsx format cannot store VBA. Select File > Save As and choose Excel Macro-Enabled Workbook (.xlsm) to retain the code.

Can I monitor a different column?

Yes. In the worksheet code, replace Me.Columns(3) with the appropriate column number or letter, such as Me.Columns(4) for column D.