iknowu99
Well-known Member
- Joined
- Dec 26, 2004
- Messages
- 1,158
Aloha
Column A contains integers; I would like to identify the minimum/s. The identifying process adds 1 to column Z and in the same row as the minimum/s.
so far I have:
Set myRange = Worksheets("temp").Range("A1:A" & Range("A65536").End(xlUp).Row)
answer = Application.WorksheetFunction.Min(myRange)
Gracias
Column A contains integers; I would like to identify the minimum/s. The identifying process adds 1 to column Z and in the same row as the minimum/s.
so far I have:
Set myRange = Worksheets("temp").Range("A1:A" & Range("A65536").End(xlUp).Row)
answer = Application.WorksheetFunction.Min(myRange)
Gracias