I have written a macro to automate sub-totalling in Excel 97, however it is having problems recognising the header rows in the data I'm trying to sub-total. The header references are definitely there, and Excel should have no problem recognising them and dosen't when I do the operation manually. However when I run the macro it produces the dialog box with message:
"Microsoft Excel cannot determine which row in your list or selection contains column labels, which are required for this command..
If you want the first row of the selection or list used as labels not as data, click OK
...."
I do want to use the first row but I don't want this message appearing. Unfortunately it isn't captured in the VBEditor as an event I can get rid of. How can I stop this message appearing and get it to automatically use the first row without asking?
Thanks
Mark
