many thanks for that, been trying to work it out for weeks.Cheers

here it is.

I can make my table grow in rows or columns but not in both, when i add a row it will not add the column i have just added and the colum will not include the row i have just added.does any one know what script i need so the addInstance knows whan i have added a new row or column.thanks.

I am new to this and just starting to get my head a round it all, is there any way you can do trigonometry calculations like TAN, ATAN or SIN in excel in a form just like adding or subtraction.e.g =$H$1*ATAN((COS(C10)-0.15116)/SIN(C10))cheersrick