Loop 20 columns Help!

M

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
 
R

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
 
M

Michael168

Hi!Ron de Bruin,

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

"Little tips solve the problems."

Regards,
Michael.
 
Top