Hello forum,
The macro below was working well a week ago. It now comes up with a Run-time error '1004': Unable to get the Average property of the WorksheetFunction class
The debugger indicates the issue lies at the row highlighted red. Any clues/help will be much appreciated.
Sub...