Column references in VBA

[Ron903]

Hi all -
New to VBA and this forum. Hoping to find a quick answer to what is probably very basic.

I am writing a macro that will loop through spreadsheets with a varying number of columns and rows. One of my needs is to find the minimum and maximum value in the active column based on an index/counter. In this case, the column reference is ColNum.

Column index/loop -
For ColNum = 1 To TotalCols

Find min and max -
FldMin = Application.WorksheetFunction.Min(rng)
FldMax = Application.WorksheetFunction.Max(rng)

What I am struggling with is how to define the range (rng) using ColNum for use in the min and max functions. Have tried several things I have seen online and I'm just not grasping the concept.

Thanks,
Ron

 

[Fluff]

Hi & welcome to the board.
Try

FldMin = Application.WorksheetFunction.Min(Columns(ColNum))

 

[Ron903]

Thank you very much! That worked perfectly. I was making that way harder than I apparently needed to. Guess I have a lot to learn...

 

[Fluff]

Glad to help & thanks for the feedback.
Unfortunately it's very easy to over complicate things and It's something we've all been guilty of at sometime or another.