mahras
06-09-2007, 11:30 AM
Hey guys,
Stumbled on this forum while trying to google up an answer for a problem I am having.
Basically I want to make a range dynamic.
For example, what I have is that:
For i = 1 to 100
Range((2+i,3),(2+i+5,3))
Next i
However, excel does not read this properly as you can't use equations as cell values when using range. So is there a way to go around that. I am trying to find the max value in a range of cells and its being a real pain to figure this out.
Would greatly appreciate any assistance. Thanks.
Stumbled on this forum while trying to google up an answer for a problem I am having.
Basically I want to make a range dynamic.
For example, what I have is that:
For i = 1 to 100
Range((2+i,3),(2+i+5,3))
Next i
However, excel does not read this properly as you can't use equations as cell values when using range. So is there a way to go around that. I am trying to find the max value in a range of cells and its being a real pain to figure this out.
Would greatly appreciate any assistance. Thanks.