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?
colPrevSheet2 is just a letter for the columnWorksheets("sheet1").Range("C" & myColCheck).Value = Application.WorksheetFunction.Max(.Range(.Range(colPrevSheet2).End(xlUp), .Range(colPrevSheet2).End(xlUp).Offset(-(myActualRow - 1))))
WorksheetFunction.Max(.Offset(1).Resize(.Rows.Count - 1))
</pre>
actually with thisDim Rng As Range
Dim myMax As Integer
Rng = Worksheets("daily").Range(pIndex & "2" & ":" & pIndex & Lastrow)
myMax = WorksheetFunction.Max(Rng)
MsgBox myMax
Rng = Worksheets("daily").Range(pIndex & "2" & ":" & pIndex & Lastrow)
I want to count from 2 row to the end..Resize(Lastrow - 1)
pIndex is a letterSet Rng1 = Worksheets("daily").Range(pIndex & "2" & ":" & pIndex & Range(Lastrow))