Lowest Number >0 in a Range

[AlexanderBB]

Hunting for this I found

Finding lowest non zero value in excel VBA

How can i get the lowest non zero value among a set of integers within excel VBA ?

www.mrexcel.com

But oddly I can't get them working
MsgBox [min(if(a1:a100<>0,a1:a100))]

I changed this to MsgBox [min(if(y23:cp23<>0,y23:cp23))]
It results in 0 which is wrong. Is it because the intent is a vertical range and mine is horizontal?

 

[StephenCrump]

What exactly do you have in Y23:CP23?

Are they numbers? Or text values?

By the way, "lowest non-zero value" is not the same as "lowest number >0" if the range can include negative numbers.

 

[AlexanderBB]

They are numbers but in text Format. no negatives. Some have trailing "=".
It's the column that's wanted. to change the Font.ColorIndex.

 

[MARK858]

Then they are text and not numbers, text is treated as greater than numbers including zero