paulypau
04-04-2017, 05:43 PM
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
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