Use of worksheet function

[Caze982]

[FONT=&quot]Hi[/FONT]
[FONT=&quot]I want to use the min method of the WorksheetFunction on a range in a workbook in sheet 1, and assing the value to a variable called lastrow, like the following:[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]LowestScore = Excel.Application.Workbooks(1).Worksheets(1).WorksheetFunction.Min(Range("B1:B5"))[/FONT]
[FONT=&quot]but i get an error 438 that says that object dosen't support this property or method.[/FONT]
[FONT=&quot]I am pretty sure that it is because that worksheet function is not at property of worksheets class.[/FONT]
[FONT=&quot]In the object browser i can see that WorksheetFunction is a property of the application class.[/FONT]
[FONT=&quot]My question is, how can i, in my code spcify in which sheet i want to use the worksheet function?[/FONT]
[FONT=&quot]As above i would think it would be:[/FONT]
[FONT=&quot]Excel.Application.Workbooks(1).Worksheets(1).WorksheetFunction.Min(Range("B1:B5"))[/FONT]
[FONT=&quot]Excel.Application.Workbooks(1).Worksheets(2).WorksheetFunction.Min(Range("B1:B5"))[/FONT]
[FONT=&quot]Excel.Application.Workbooks(1).Worksheets(3).WorksheetFunction.Min(Range("B1:B5"))[/FONT]
[FONT=&quot]Sincerly[/FONT]
[FONT=&quot]Christian[/FONT]

 

[RoryA]

It should be:

LowestScore = Excel.Application.WorksheetFunction.Min(Workbooks(1).Worksheets(1).Range("B1:B5"))

 

[bukimi]

Try adding it in the last part (Range):

Application.WorksheetFunction.Min(Workbooks(1).WorkSheets(1).Range("B1:B5"))

RoryA was faster, I can't delete my post now...