Hi I have this...and it doesn't work. why?
daily it's the sheet with different columns and
and pIndex says which column and numRow says the total of the lines for that row.
I started from 2 (pIndex & "2"...) because i want to find the max from row 2 to the end.
what's wrong here?
where myColCheck it's a number of the row where i'm going to put the valuesWorksheets("sheet2").Range("C" & myColCheck).Value = WorksheetFunction.Max(Worksheets("daily").Range(pIndex & "2:" & pIndex & numRow))
daily it's the sheet with different columns and
and pIndex says which column and numRow says the total of the lines for that row.
I started from 2 (pIndex & "2"...) because i want to find the max from row 2 to the end.
what's wrong here?