This post will guide you how to insert the contents of a paricular into the header or footer cell in your active worksheet with VBA Macro in Excel.