Hi,

I recorded the following macro in excel 2010....

ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$F$87"), , xlYes).Name = _
"Table1"
but now realise that the size changes each day. Please could some one help with code to build a table with a changing number of rows

many thanks
Jon