Djblois
03-14-2007, 12:17 PM
I already know how to copy the contents of a cell into a header but now I want to be able to copy the header into a cell. Here is the code I tested:
Range("D7").Value = ActiveSheet.RightHeader.Value
Range("D7").Value = ActiveSheet.RightHeader.Value