That is very helpful thanks, now I just have to incorporate it into my sheet that has frozen panes, but as it is it shows the range as seen in the un frozen area no problem.