Selection Clear Content

[paulypau]

Hello,

I don't have a lot of experience with macros but I have an issue as the person who develop the macro is unable and we are unable to fix the issue.
The Excel file / Macro was working properly, until there was a company system update and it's not longer working - after reviewing the code I was able to determine that the macro is having issues in this point

Public Sub Clean()
ActiveWorkbook.Worksheets("Review").Activate
Rows("2:2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
End Sub

At this point the macro starts calculating and stops and Excel crashes

[AlphaFrog]

There is nothing in the code alone that should cause Excel to crash. There must be some other combination of worksheet formulas and\or other macro code in the worksheet's code module that is contributing to the problem.

If you right-click on the Review sheet tab and select View Code from the pop-up context menu, do you see any other code in the worksheet's code module?

Is there a lot of formulas on the worksheet?

Can you attach a sanitized version of your workbook that illiterates the problem?

[guru008]

Your code is fine

just enter your code into Module instead of Sheet if it is in sheet.