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

--
Message posted from http://www.ExcelForum.com

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Michael168 " wrote in message ...
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 and
biggest value.

Thanks
Michael


---
Message posted from http://www.ExcelForum.com/

Hi!Ron de Bruin,

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

"Little tips solve the problems."

Regards,
Michael.

Ron de Bruin wrote:
*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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Michael168 " wrote i
message ...
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 and
biggest value.

Thanks
Michael


---
Message posted from http://www.ExcelForum.com/


--
Message posted from http://www.ExcelForum.com