I am currently using C through H to find the find the smallest value by using
the following formula
{=min(if((C4:H4)0,(C4:H4))}

But now i want to have automatically find the smallest value if i inserted a
new column. So i used this formula

{=min(if(Indirect("C"&Row()&":"&address(Row(),Colu mn()-1))0,Indirect("C"&Row()&":"&address(Row(),Column( )-1)))}

But its not working i am getting a #value error.

So what is wrong, i dont see it