| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting column number of max value
I have the following VBA code to get "max value" and "the column number"
where max value is. I can get the max value, but not the column number. Any suggestions? Thanks. Sub model() For i = 1 To 16 Set eachrow = Range("data").Rows(i) maxvalue = Application.WorksheetFunction.Max(eachrow) colnumber = maxvalue.Column Cells(i, 10) = maxvalue Cells(i, 11) = colnumber Next End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help!!! Extracting a number to line up with a different number | Excel Discussion (Misc queries) | |||
| extracting a number | Excel Programming | |||
| Populate a column by extracting unique values from another column? | Excel Worksheet Functions | |||
| Extracting same column from large number of workbooks | Excel Worksheet Functions | |||
| Extracting the column letter and row number | Excel Programming | |||
Threaded Mode
