Excel - VBA: I need support to link the Max function

Navigation
0

How can I reference a column of a certain sheet using the below command in VBA? 

Application.WorksheetFunction.Max
    
asked by anonymous 29.09.2016 / 23:00

1 answer

1

Just reference the Range you need.

Example: 

Application.WorksheetFunction.Max(Worksheets("Plan1").Range("A1:A10"))
    
11.10.2016 / 19:10
Problems adding numbers to an ArrayList Unable to connect: No connection could be made because the target machine actively refused them