I have a VBA Macro which pulls in data from a CSV and then attempts to sub total the data using the following:

Selection.Subtotal GroupBy:=4, Function:=xlSum, totallist:=Array(9, 10, 12, 14, 15, 17), Replace:=True, PageBreaks:=False, SummaryBelowData:=True

However, because there are no headings it stops the macro and displays an error box which says "Microsoft Office Excel cannot determine which row in your list or selection contains column labels"

It offers an OK, CANCEL or HELP select. If you click OK it subtotals anyway.

Is there way to either stop this dialog appearing or to make VBA reply OK automatically?