|Well, let's start with the fact that in most cases you don't have to Activate a Sheet (or Select a Range) to perform a VBA action on it. That's an inefficient way to write code.|
If you want to write to the Stats sheet, just use this:
Sheets("Stats").Cells(58, 2) = OpenedCount
Sheets("Stats").Cells(59, 2) = ClosedCount
Next, I'm going to hazard a guess and say that this code resides in the Inquiry sheet.
I say this because VBA doesn't really care which sheet is Active when you use instructions like Cells(58, 2) = OpenedCount. It's going write to Cells(58, 2) in the sheet in which the code resides.
Therefore, there doesn't appear to be any need to activate any sheets in your code. Simply refer to the sheet (by Name or by Position number) you want to perform the action on as I did above.