Need to split excel file with header into smaller files with same headers in excel

The macro provided by KERRY2277has done exactly what my request was including the heders. Thank you for the assistance KERRY2277 you have made my day.
I now realised that I want the NEWto be created without any headers and must be in csv format. is this osmething easily done or do I need to log another request?
Thanks for you generous help on this topic.