Two alternatives
1. Use script from 22-AUG and copy the value from the forumla entry (or double-click cell, drag mouse over values, press ctrl-c) which uses Windows copy instead of Excel cell copy.
2. Modify script as below. With this, you need to press ESC to get out of Excel copy mode...
Simplification of above post. Also, when using code from first post, I was getting slow response once I updated data in a cell. This approach does not use conditional formatting and does not affect the speed after updates:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)...
Simplification of above post. Also, when using code from first post, I was getting slow response once I updated data in a cell. This approach does not use conditional formatting and does not affect the speed after updates. Also it does not require a separate module for the ActRow and ActCol...
This code is the same concept but does not need conditional formatting.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Len(ActCol) > 0 Then 'Not first time in worksheet
Cells(ActRow, ActCol).EntireRow.Interior.ColorIndex = xlColorIndexNone...
