Hi,
I recorded the following macro in excel 2010....
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 rowsActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$F$87"), , xlYes).Name = _ "Table1"
many thanks
Jon