Afternoon,

I want to create a script (or macro) that will run a program that looks at
speific cells, get their values (regards if value is zero) and display the
results in A1. Current i'm using the below line but it is tedious and tiring
considering i have over 50 columns. Please advise when you can. Cheers.

Below line, the result is displayed in A1 as "
etc...
=CONCATENATE($M$1,"@",$AT$2,"@",C37,"@",ROUND(F37, 2),"@",ROUND(F38,2),"@",ROUND(G37,2),"@",ROUND(G38 ,2),"@",ROUND(H37,2),"@",ROUND(H38,2),"@",ROUND(J3 7,2),"@",ROUND(J38,2),"@",AP37,"@",ROUND(AP38,0))