If column A cell 1 has anything in it, I want to past this formula 
"=IF(A1="","",CONCATENATE("network ",IpAnd(A1,B1)," ",255-C1,".",255-D1,".",255-E1,".",255-F1))"
in column H on the same row.
I want it to simply look down Column A doing the same thing until blank cell found.
Of course the formula would need to have the row number changed each time or have simply look in the same row.