OS: MS XP
Excel: 2002

I have a macro which I use to update the page Settings in an Excel file.
What I dont know how to do is:
1) Have the macro read the value at the start of its execution from cell B1.
2) Store the value found in cell B1.
3) At the end of the macro execution write the value from B1 to the Custom
Header section in the page setup. Left Section:.

Thanks in advanced.

--
Richard