why I can't find the max with this?

[earp_]

Hi I have this...and it doesn't work. why?

Worksheets("sheet2").Range("C" & myColCheck).Value = WorksheetFunction.Max(Worksheets("daily").Range(pIndex & "2:" & pIndex & numRow))

where myColCheck it's a number of the row where i'm going to put the values
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?

 

[Andrew Poulsom]

It's hard to tell what's wrong without knowing what error you get and the values of myColCheck, pIndex and numRow at the time.

 

[earp_]

right, but it has to be
WorksheetFunction.Max
or
application.Max
?

 

[Richard Schollar]

Hi

Please don't be offended by this, but you have been posting many threads to this Board concerning VBA coding and you have got into a very bad habit of never posting your full code and yet expecting the readers of your posts to decode what is going on in your whole routine to suggest fixes.

This is very difficult for anyone to do without the whole code. For instance, it is impossible to tell from your code what pIndex is defined as, what value it holds, and where it gets this value from.

Also you state "it doesn't work" and then completely fail to explain how and why it doesn't work - do you get a debug error or is it simply a case of the result you get is not the one you expect? Again, with no details it is impossible for anyone to tell.

So in future, if you want to post questions that will get answered quickly without to and froing to get the full picture, just follow the following guidelines:

1. Post your full code
2. Explain what happens with your current code (not "it doesn't work") remembering to quote any error values received and also on which lines errors occur
3. Explain what you would like to happen in your current code

This way you will receive replies which will resolve youur issue much faster than otherwise.

 

[earp_]

No worries.
Only one thing.
When you say about 'posting your full code' you mean with an .xls file?

 

[Andrew Poulsom]

right, but it has to be
WorksheetFunction.Max
or
application.Max
?

It can be either. This may interest you:

http://www.dailydoseofexcel.com/archives/2004/09/24/the-worksheetfunction-method/''/

 

[earp_]

Btw thanks to everybody.
It's just I don't want to ask anyone to debug something like 1200 lines.
Could be worse though.
I will try to explain better next time with the whole code.
thanks again