Use Excel VBA Intersect to Detect Changes in Column C
Question details
Run VBA code when an edited cell or range includes any cell in column C.

- 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.
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.
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.
Right-click the worksheet tab you want to monitor and select View Code.
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
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.
Select File > Save As and choose Excel Macro-Enabled Workbook (.xlsm) if the workbook is not already saved in that format.

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.

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.




