Has anyone ever seen or created a header that changes when you have the screen frozen and you scroll down. Typically if you freeze a screen you can label above the freeze line what is in that column so when you scroll down the label is above the freeze line. But frequently i use different ranges in lower portions of the sheet with different types of information. These seperate ranges have header labels above them, but these headers disappear under the upper-freeze portion of the screen when you scroll down. What i'm looking for is a header label that displays and changes to the appropriate header for the range that is currently on screen. ???
Tom
Tom