MIN & MAX VBA commands not seeming to work

[Danexcel]

Could someone check out the VBA code here?

I would like someone to explain the reason why when the program is run, the maximum value in column S successfully is selected by being colored in pink, but the minimum in column R between those pink max's (indicated by the entire row outlined in red) is not the minimum.

In other words, look at the numbers in column R. Only the 14.08 rows are supposed to be boxed in red. I can't understand why the 30.08 and the 46.08 are boxed in red??? And puzzling to me is why the 46.08 near the top are boxed, yet the 46.08 near the bottom are not boxed.

Thank you!

Please Login or Register  to view this content.

[DonkeyOte]

Just a quick heads up, it's possible DstRng is incorrect depending on active sheet at run time given you're not fully qualifying, ie I suspect it should be:

Please Login or Register  to view this content.

That said I've not looked at your file... but I suspect the above requires correction nonetheless.

[Danexcel]

Just a quick heads up, it's possible DstRng is incorrect depending on active sheet at run time given you're not fully qualifying, ie I suspect it should be:

Please Login or Register  to view this content.

That said I've not looked at your file... but I suspect the above requires correction nonetheless.

Thanks for the information.
I tried replacing the one line in the code with yours, but I got an error with that line as the problem.
Was there another place I also needed to copy it into?

[DonkeyOte]

For whatever reason I failed to encase the range within quotations...

[DonkeyOte]

OK I've just looked at this properly... try the below (I've tried not to adjust from your existing code unless nec.)

Please Login or Register  to view this content.

The key (IMO) is to establish the MIN for the MAX prior to commencing the Loop, this is done via the Evaluate.

[Danexcel]

I'm trying your suggested code now. Thank you!

One thing I'd like to ask is, on the INPUT tab on the worksheet I only want the rows outlined in red from the DETAILS sheet to be listed. It seems now when I run your code nearly 300 lines show up on the INPUT page, when I really want only the actual handful of rows that are outlined in red from the DETAILS page.

[DonkeyOte]

Given the way you're defining DstRng you need to resize it before using it as basis for paste, ie use:

Please Login or Register  to view this content.

[Danexcel]

Hello DonkeyOte,

I've been busy but I swung back round to working on this. I originally did not know where to add the snippet you sent last, but I believe I figured it out, and I am getting better results. I will mark as solved for now!

Thank you very much.