what is the difference between MAX and Application.WorksheetFunction.Max ?

[earp_]

what is the difference between them.
If i know how many rows there are in a column I guess i can just use MAX, right?

 

[mortgageman]

what is the difference between them.
If i know how many rows there are in a column I guess i can just use MAX, right?

Corrrect. In fact if you are in regular Excel, you SHOULD NOT use application.etc. That is for using MAX (or most other native Excel functions that do not have counterparts in VBA) in VBA

 

[earp_]

can you help me with this?

Worksheets("sheet1").Range("C" & myColCheck).Value = Application.WorksheetFunction.Max(.Range(.Range(colPrevSheet2).End(xlUp), .Range(colPrevSheet2).End(xlUp).Offset(-(myActualRow - 1))))

colPrevSheet2 is just a letter for the column
myActualRow is the number of the elements in a column less one, because i don't want to count the first row.
How can i find the max for 'Worksheets("sheet1").Range("C" & myColCheck).Value =...'

in a previous post i've got this help

WorksheetFunction.Max(.Offset(1).Resize(.Rows.Count - 1))
</pre>

 

[earp_]

Maybe I've got it.

 

[earp_]

No I didn't...
what is wrong with this?

Dim Rng As Range
Dim myMax As Integer
Rng = Worksheets("daily").Range(pIndex & "2" & ":" & pIndex & Lastrow)
myMax = WorksheetFunction.Max(Rng)
MsgBox myMax

actually with this

Rng = Worksheets("daily").Range(pIndex & "2" & ":" & pIndex & Lastrow)

 

[xld]

Looks like you want

Dim Rng As Range
Dim myMax As Variant
Set Rng = Worksheets("daily").Cells(2,pIndex).Resize(Lastrow - 1)
myMax = WorksheetFunction.Max(Rng)
MsgBox myMax

 

[earp_]

why did you write

.Resize(Lastrow - 1)

I want to count from 2 row to the end.
So i guess with Cell(2,.... i have this and I don't need the Resize, right?

 

[earp_]

it says 'out of range'

 

[xld]

We need more info, more context to sort that out.

 

[earp_]

right.

Set Rng1 = Worksheets("daily").Range(pIndex & "2" & ":" & pIndex & Range(Lastrow))

pIndex is a letter
Lastrow is a how many elements there are in column pIndex
I want to find the max from row2 to Lastrow of pIndex

I have an error on that line