Loop 20 columns Help!

[Michael168]

Hello!VBA expert,

Can someone tell me how to loop in VBA?

I want to loop through 20 columns in order to get the smallest an
biggest value.

Thanks
Michae

 

[Ron de Bruin]

If i understand you correct then
You can use a function.

Sub test()
MsgBox Application.WorksheetFunction.Max(Range("A1:d100"))
MsgBox Application.WorksheetFunction.Min(Range("A1:d100"))
End Sub

 

[Michael168]

Hi!Ron de Bruin,

Thanks for the tips and you understand correctly what I meant.

"Little tips solve the problems."

Regards,
Michael.