VBA & Macro Problems

Fix Copy and Paste Blocked by an Excel SelectionChange Macro

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

Allow copy and paste while retaining a worksheet macro that recalculates when cells in columns G:K are selected.

Fix Copy and Paste Blocked by an Excel SelectionChange Macro
Product
Microsoft Excel
Device & OS
not provided
Scenario
A Worksheet_SelectionChange event recalculates the worksheet when the selection intersects columns G:K.
Observed behavior
The recalculation triggered by the selection event interrupts copy and paste operations in the affected range.
Before you start

Locate the worksheet that contains the SelectionChange event and confirm that the workbook is saved in a macro-enabled format, such as .xlsm. Enable macros only if you trust the workbook.

Solution 1Recommended

Skip the SelectionChange calculation during copy or cut

Check Excel's CutCopyMode before recalculating so an active copy or cut operation is not interrupted by the event.

1
Open the worksheet code

In Excel, open Developer > Visual Basic. In the Project pane, find the affected workbook and double-click the worksheet that contains the Worksheet_SelectionChange procedure.

2
Update the event procedure

In the worksheet code window, update the existing Worksheet_SelectionChange procedure to check CutCopyMode before the calculation. For the event described here, use: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Application.CutCopyMode = xlCopy Or Application.CutCopyMode = xlCut Then Exit Sub If Not Intersect(Target, Me.Range("G:K")) Is Nothing Then Me.Calculate End Sub If the existing event contains other actions, add the CutCopyMode check before the calculation rather than creating a second SelectionChange procedure.

3
Save and test

Save the workbook as an .xlsm file, return to the worksheet, and copy or cut cells in columns G:K. Select a destination and paste, then select a cell in G:K outside an active copy or cut operation to test the calculation.

Skip the SelectionChange calculation during copy or cut
Calculation is skipped during copy or cut: When copy or cut mode is active, the event exits without recalculating. The calculation is not queued; it runs on a later qualifying selection when copy or cut mode is no longer active.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. It can help you move routine spreadsheet work between applications, but it does not fix Excel's VBA event behavior; verify macro compatibility before migrating a macro-dependent workbook.

Edit spreadsheet data with familiar worksheet toolsOpen and edit Microsoft Excel XLSX filesUse a free, lightweight Office alternative for routine spreadsheet work
microsoft office alternative - wps office

Frequently Asked Questions

Why does selecting a paste destination interrupt copying?

Selecting a destination fires Worksheet_SelectionChange. If that event recalculates the worksheet while Excel is in copy or cut mode, it can interrupt the operation. Check Application.CutCopyMode before running the calculation.

Where should I put the CutCopyMode check?

In Developer > Visual Basic, open the affected worksheet's code module and place the check near the start of its existing Worksheet_SelectionChange procedure, before the calculation.

Will the macro still recalculate when I select columns G:K?

Yes, when Excel is not in copy or cut mode. If copy or cut mode is active, the procedure exits and skips that calculation.

How do I keep the macro after saving the workbook?

Use File > Save As and choose Excel Macro-Enabled Workbook (.xlsm). When reopening the file, enable macros only if you trust its source.