Find Max Value based on Another Column in VBA

[Anuviswan]

Hi

I have 3 columns

A B C
1 2.3 1
3 4.3 1
4 3.4 1
2 5.6 2
5 4.4 2

First I want to find Max value of B where Column C is 1 and then I need to copy that entire row to a new Sheet.
This needs to be done using VBA Macro.
Can any one please help ?

Thanks in Advance
Anu

[patel45]

Please Login or Register  to view this content.

[Anuviswan]

Hi
This Works, but loop gets very slow when the excel is lengthy and there is we have to go through to , say a 100 values of column 3.
Is there a way we can do this without a loop ? something like using a formula from VBA ? What are WorkSheetFunctions used for ?

Regards
Anu