Finding Maximum Within Range (Looped)

From: "Jacob" <jlongton@xxxxxxxxx>
Date: 8 Sep 2006 05:35:42 -0700

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

.

Follow-Ups:
- Re: Finding Maximum Within Range (Looped)
  - From: Die_Another_Day

Prev by Date: Re: How to Unprotect Project Protection through Macro
Next by Date: Re: Getting a macro to work in all workbooks
Previous by thread: Maximum number of DDE links?
Next by thread: Re: Finding Maximum Within Range (Looped)
Index(es):
- Date
- Thread

Relevant Pages

Re: Finding Maximum Within Range (Looped)
... For q = 0 To span Step delta 'loop for calculating max of each column ...
(microsoft.public.excel.programming)
Re: Finding Maximum Within Range (Looped)
... For q = 0 To span Step delta 'loop for calculating max of each column ...
(microsoft.public.excel.programming)
Re: Finding Maximum Within Range (Looped)
... For q = 0 To span Step delta 'loop for calculating max of each column ...
(microsoft.public.excel.programming)
Re: Finding Maximum Within Range (Looped)
... For q = 0 To span Step delta 'loop for calculating max of each column ...
(microsoft.public.excel.programming)
Re: Finding Maximum Within Range (Looped)
... The first solution did not work although I clearly made a mistake by ... For q = 0 To span Step delta 'loop for calculating max of each column ...
(microsoft.public.excel.programming)