Using "Application.WorksheetFunction.max"

[lucasar]

Hello everyone.

At some point in my code I'm using something like this:

Please Login or Register  to view this content.

I would like to set the interval between two cells, instead of each individual cell. Something like this:

Please Login or Register  to view this content.

That doesn't work, though. Which is the correct syntax?

Thank you for your attention.

[Norie]

Try this.

Please Login or Register  to view this content.

Or this.

Please Login or Register  to view this content.

[StuCram]

Hi lucasar,

I think this might work.

Please Login or Register  to view this content.

Notes:
1. Use Range(first Cell, last cell) to specify the range in VBA. See example above.
2. I wouldn't recommended in this case using x as the result and also as part of calculations in this case;
that's why I added another variable for the resulting max value.

[lucasar]

Thank you guys, problem solved.