Good day,

I have a function in a module, in which I would like to state that the
current visible worksheet should be treated as the active one, because I do
not know during execution what the sheet name will be. In the example below
the sheet name is hardcoded, what is the better solution?

With ActiveWorkbook
With .Worksheets("Titans")
.Range("M5").Value = 5
End With
End With

Kind regards

George