Hi all,
I am trying to write a line of code (within a macro) to check for the minimum value in 3 columns. I have heard mention of a Min function, but cannot find how to use it.
As a rough idea, this is what I am trying to achieve:
If Cells(8, 31).value = Min(Cells(7, 31).value, Cells(8, 31).value, Cells(9, 31).value) Then
Can someone assist me in the correct formatting of this command?
Cheers
John
I am trying to write a line of code (within a macro) to check for the minimum value in 3 columns. I have heard mention of a Min function, but cannot find how to use it.
As a rough idea, this is what I am trying to achieve:
If Cells(8, 31).value = Min(Cells(7, 31).value, Cells(8, 31).value, Cells(9, 31).value) Then
Can someone assist me in the correct formatting of this command?
Cheers
John