Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Maximum Within Range (Looped)
There is an error with the 3rd line of the code below, and I cannot
figure out why. I guess I don't understand how to use "Range" with indexing very well. Is there a better way to go about this? thanks. Count2 = 0 For q = 0 To span Step delta 'loop for calculating max of each column Max = Application.Max(Range(Cells(21, Count2), Cells(100, Count2))) Cells(19, Count2 + 2) = Max Count2 = Count2 + 1 Next q |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding maximum, minimum in a range consists both Positive and Negative numbers | Excel Worksheet Functions | |||
Finding a maximum with VLOOKUP | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | Excel Worksheet Functions | |||
Finding Maximum | Excel Worksheet Functions |