Finding max value of column in a non-active sheet.

I'm trying to find the maximum value in all of the non-empty cells of a single column, column A, of an inactive sheet.

I've been trying to use this line:

maximum = Application.WorksheetFunction.Max()

This seems easy, but I can't think of what to use as the argument for max()

Any suggestions?

Maximum = Application.WorksheetFunction.Max(Worksheets("Insert Worksheet Name Here").Range("A:A"))

Hi welcome to the forum.

You may try something like this......

Sub FindMax()
Dim ws As Worksheet
Dim maximum As Long
Set ws = Sheets("Sheet2")       'Assuming Sheet2 is your inactive sheet.
maximum = WorksheetFunction.Max(ws.Range("A:A"))
End Sub

Does this help?

You're welcome. Happy to help.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.