excel vba - Adding a title after spreadsheet and macros are written -

i have been making spreadsheet sorting macros work past week. finished coding(98% of it) , boss tells me need title @ top of spreadsheet when prints. of codes have written error when shift data down in order add title in row 1. there way add title without having happen? i'm novice vba around , recieved decent amount of project bear ignorance please! in advance.

you can use page header settings add title, without affecting rows themselves.