Identifying maximum values within a range of cells

[SBF12345]

Greetings,

I would like to identify a maximum value within a range of cells. I am currently trying the line below, but am not apply the correct syntax. What is the best structure to use for similar types of operations? Also, what rules surround the definition of the row and column identifiers in the .cells property?

If Cells(a, "E").Value = WorksheetFunction.Max(Range(Cells((a+10),"E"):Cells((a-10),"E")).Value Then

 

[Rick Rothstein]

Greetings,

I would like to identify a maximum value within a range of cells. I am currently trying the line below, but am not apply the correct syntax. What is the best structure to use for similar types of operations? Also, what rules surround the definition of the row and column identifiers in the .cells property?

If Cells(a, "E").Value = WorksheetFunction.Max(Range(Cells((a+10),"E"):Cells((a-10),"E")).Value Then

You could use this to get the maximum value in Column E...

MaxVal = [MAX(E:E)]