What kind of "range" does WorksheetFunction.Max need?

[spacely]

Starnge problem here (maybe my dumb error...)

This works:

Please Login or Register  to view this content.

This doesn't:

Please Login or Register  to view this content.

I need variable columns and rows, that's why I need the 2nd style. At the beginning I Dim B1var() As Variant and then again ReDim B1var(1 To numbldsec) where numbldsec is an integer, but not sure that matters. startrow and endrow are not declared, but check out as integers.....

Any ideas?

[cnodnarb]

Well, in your second msgbox B1var(i) startrow and B1var(i) endrow are the same number. ie. B1var(i) has the same value in both spots.

ReDim'ing the variant does not cause there to be two separate values for B1var(i). You need a second variant, or you need another count variable other than 'i'.

(I Think)

[Jacc]

Isn't it something about that you need to select the worksheet first if you gonna use the Cells function?

[AlphaFrog]

You also should qualify each Cells statement with its own worksheet reference.

Please Login or Register  to view this content.

[protonLeah]

How are you filling "B1var"?

[spacely]

AlphaFrog, your suggestion worked. I just needed to get the min's and max's of each column, as the column number i changed. Also the start and end rows for each column are variable. B1var array are just row numbers.